I have a fairly simple query:
The name field is my category field. This query returns results across all categories (name field). What I need is all records with the category of horseracing and then find ones with keys in the title OR description.Code:
SELECT * FROM table WHERE name = 'Horseracing' AND DESCRIPTION LIKE '%tips%' OR TITLE LIKE '%tips%' LIMIT 0, 25
Can you help?
Thanks, great site.