How can I add search functionality into my PHP website?

Question

Duplicate:

How would I implement a simple site search with php and mySQL?

I want to insert a search functionality into an existing website. The site is database driven. What is the best way to achieve this? Should i just simply go ahead with the query select * from tables where field like user input? Is there a better way to index the site?

Answer 1

This question is pretty much a duplicate of this one:

http://stackoverflow.com/questions/386914/how-would-i-implement-a-simple-site-search-with-php-and-mysql