General search on DB! Urgent!

[Anon]

Hi!

I'm coding a content manager in PHP, using mySQL as database back end.

Now I don't know how to create a query that will search the entire table for a keyword (no matter the field where it might be found).

Can you please help ? This seems a pretty silly question perhaps...!

Thanks,

Turbinho

[dstockto]

SELECT * FROM TABLE WHERE (field1 LIKE '%word%') OR (field2 LIKE '%word%') or (field3 LIKE '%word%)....

[phpbigot]

...just to flesh out his answer, and be more explicit:

say you tell people to separate keywords with a comma. So on the page that you post to do this:

1 - explode() the keywords using your delimiter (in this case, a comma)

2 - get the # of keywords with count()

3- do a for loop and generate your WHERE clause (WHERE (field1 LIKE '%word%') OR (field2 LIKE '%word%') or (field3 LIKE '%word%)....
)