simple search question

semtex

I want to have a simple search function on my website.
The user enters one or more keywords and clicks 'search' and then I want php to search the WHOLE database for these keywords. So I mean it has to search ALL tables in the database (and list the results).

How can I do this simply or what is the sql query for this?

Thanks.

WaveyGravy

You could take a look at:

http://www.hotscripts.com/PHP/Scripts_and_Programs/Search_Engines/

Most use php & mysql, so I'm sure you'll be able to find something to meet your requirements.

Hope that helps? 🙂

semtex

hmmm. i hoped there would have been an easy mysql query something like:

SELECT * FROM 'database_name' LIST $keyword

semtex

and what's the query for doing a search for a string in one table?

is that correct:

SELECT * FROM table WHERE LIST $keyword

bobot

query statement should be:

"Select * from table where column_name like '%$Keywords%' "

Hope this help.

tomhath

Ahhh for the good old days, when you could just grep every file in a directory in one command. Sorry, can't do that with databases; you can search any column in any table, but you have to do them one at a time.

semtex

ok thanks i'll do the search for every table apart.