Query for auto-complete

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
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Query for auto-complete

Post by GeXus »

I'm setting up an autocomplete script (http://interface.eyecon.ro/demos/autocompleter.html) and i'm trying to determine the best method for storing the "auto complete" values... This will be for keywords, so I could do just a one row table that could have hundreds of millions of records, I could store it in a text file..... What do you think would be the fastest method for doing this and if using mySQL, should I use like% or regex?

Thanks!
Post Reply