Query help

PHP
1

Why doesn’t this query work

SELECT *
FROM all-data
WHERE sea = ‘2010’
AND ht = ‘A’ OR at = ‘A’

The problem is that the where sea =‘2010’ doesn’t seem to work. If I remove the where clause the query works if i remove the and section the query works but when they are both put together it fails and doesn’t recognise the 2010 aspect of the query.

2

Try this

SELECT *
FROM all-data
WHERE sea = ‘2010’
AND (ht = ‘A’ OR at = ‘A’)

3

excellent thank you