I have one table with three fields, id, name, description.
I want to perform a keyword search on the table in the description field and then return the id of each record that has a keyword match.
I dont think this will work:-
"SELECT id FROM table WHERE description LIKE '$keyword'"
Any ideas to point me in the right direction?
ps. I dont need to know how to display the results, its just the initial search i am stuck with
Thanks in advance!