Best way to do a search engine (just a database search, not a web search engine)

[tibberous]

I want the user to put in a search term and search the database for it. What would be the best way to do that?

[benjaminbeazy]

depends on what data users are searching. and a lot of ther things. maybe you could provide more information as to what data, database type, etc.

[tibberous]

Lets say it is just a single field from a database.

 

Should I do something like:

 

$searchterm = mysql_escape_string($searchterm);

 

mysql_result("select * from table where description like='%$searchterm%'");

[mmarif4u]

Yes u can.

Its upto u which sort of searcing method u wana use.

But the query u write is ok.