PHP/MySQL Search Engine

[emcb_php]

Hi,

I have a few mysql tables, and i want to be able to search for a specific keyword in the *_keyword column but i dont know how to scruct the sql. Any sql gurus?

Cheers,

Elfyn

[Anon]

select * from yourtable
where _keyword like "%yourkeyword%";

or if you want it to be direct then replace the bottom line with:

where _keyword = "yourkeyword";

Is this what you meant?