Names database advanced search

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
a_naguib_2000
Forum Newbie
Posts: 5
Joined: Fri Jul 22, 2005 7:33 am

Names database advanced search

Post 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??
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

SOUNDEX() maybe?
Post Reply