[RESOLVED] Is my SQL query faulty?

[Jon12345]

I want to see if I am using the WHERE statement correctly. Is this the correct syntax?

SELECT * FROM tasks WHERE (status='Not Started' OR 'In Progress' OR 'Pending') AND (accountable='Jon' OR creator='Jon') ORDER BY priority

Thanks,

Jon

[Jon12345]

Found my own mistake. Sorted!