I have 4 tables that i need to search through for a user-specified word/phrase... whats the best way to do this and also, it needs to have a lot of room for people to screw up.... i.e. someone would be searching for an asian name, so it may be fairly off from what it actually is stored as in the table. Thanks in advance.
BTW - Don't make it simple... more complex the better, i only have basic knowledge of MySQL - I want to learn more
MySQL searches...
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
you might want to take a look at
viewtopic.php?t=24604&highlight=google+mean
and also generally searching for words in the database is used like this
might want to read up about it over at http://dev.mysql.com/doc/
viewtopic.php?t=24604&highlight=google+mean
and also generally searching for words in the database is used like this
Code: Select all
$sql = "SELECT * FROM `table` WHERE `content` LIKE '$yoursearch'";A bit more advanced is MySQL's fulltext search, see viewtopic.php?t=21449&highlight=mysql+fulltext