Names database advanced search
Posted: Thu Jul 19, 2007 7:26 am
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??
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??