What is the correct way to do this query?

[webhead22]

I have a fairly simple query:

SELECT * FROM table WHERE name = 'Horseracing' AND DESCRIPTION LIKE '%tips%' OR TITLE LIKE '%tips%' LIMIT 0, 25

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.

Can you help?

Thanks, great site.

[r937]

this is your query (formatted for readability) --

SELECT * 
  FROM table 
 WHERE name = 'Horseracing' 
   AND DESCRIPTION LIKE '%tips%' 
    OR TITLE LIKE '%tips%'

the problem you are having is the precedence of ANDs over ORs

your query is actually evaluated as though it had parentheses like this --

SELECT * 
  FROM table 
 WHERE (
       name = 'Horseracing' 
   AND DESCRIPTION LIKE '%tips%' 
       ) 
    OR TITLE LIKE '%tips%'

what you probably wanted was the following --

SELECT * 
  FROM table 
 WHERE name = 'Horseracing' 
   AND (
       DESCRIPTION LIKE '%tips%' 
    OR TITLE LIKE '%tips%' 
       )

see the difference?

when mixing ANDs and ORs, always code your own parentheses to control the evaluation sequence