Page 1 of 1

Names database advanced search

Posted: Thu Jul 19, 2007 7:26 am
by a_naguib_2000
Hi all,
I have a problem..
I need to make a database with mysql with about 50,000 names and details about them..
The problem is that I need to make an advanced search function that can get all the names which are similar to the search query, for example, when the user searches for "jessy", the search results should include all the variations of jessy like "jessy", "jessi", "jissy", "jess", "gessy", "gessi", "jessika", "jessica", ... etc.

How to do such a function? and do you think using regular expressions in such cases is overloading mysql or apache server or will cause problems when doing thousands of queries in the same time??

Posted: Thu Jul 19, 2007 11:25 pm
by feyd
SOUNDEX() maybe?