Search a keyword in a DB

[mcuk2000]

Let's say I have a DB of world restaurants+description(over 300k+ values).
I wanna make a local search, and every time a user searches a keyword, I want to find relevant results, in the restaurant description, in milli-seconds.

My current mysql query function (against command based)takes over 12 seconds a search, too long.

What would be the best solution? Any open source script solution?

 

[ozonew4m]

what query are you using?
what version of mysql are using?
have you tried mysqls fulltext search?

MySQL :: MySQL 5.0 Reference Manual :: 11.8 Full-Text Search Functions

 

[bubbles]

You can look at the "LIKE" keyword in MySQL too.

MySQL :: MySQL 5.0 Reference Manual :: 11.4.1 String Comparison Functions

 

[1EightT]

myisam fulltext is very fast

 

[OlegBkk]

the page that will load the list of diners accordingly his geo location, perhaps?
So, the Manchester fella won't browse through NY pubs and rest-n"s. And his search should be limited likewise to reasonable location, I guess ...
MySQL + PHP