Jump to content

Names database advanced search


a_naguib_2000

Recommended Posts

Hi all,

This is my first post here in phpfreaks.com and 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??

Link to comment
https://forums.phpfreaks.com/topic/60744-names-database-advanced-search/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.