Page 1 of 1

MySQL searches...

Posted: Wed Dec 08, 2004 8:40 pm
by Todd_Z
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

Posted: Wed Dec 08, 2004 9:25 pm
by John Cartwright
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

Code: Select all

$sql = "SELECT * FROM `table` WHERE `content` LIKE '$yoursearch'";
might want to read up about it over at http://dev.mysql.com/doc/

Posted: Wed Dec 08, 2004 10:07 pm
by Todd_Z
Well... i can do the primitive, trivial searches - I'm looking for complicated algorithms...

Posted: Thu Dec 09, 2004 3:28 am
by patrikG
A bit more advanced is MySQL's fulltext search, see viewtopic.php?t=21449&highlight=mysql+fulltext