I want to Query the database (3 fields) and find all matches for a particular word. I want to search both the name, website and the category field for this word.
If I query for the word jenna it shoudl return all records of which either the name, website or category contains the word jenna.
If you need more info please ask. Im using phpMyAdmin
Ps a next step will be to convert this into php code and use a textbox so the user can search the database for whatever word he wants and get the results displayed.
WHERE `name` = "jenna"