This SELECT statement is driving me crazy… unless I am missing something it should work.
I am using PHP 7.2.
My SELECT statement is:
SELECT firstName, emailAddress FROM mailing_list WHERE unsubscribed="" OR unsubscribed IS NULL AND verified=“y” AND active="" OR active IS NULL
A screenshot of my DB is below… this query should return 2 results uniqueID 15 and 20 however it is also returning uniqueID 10… WHY!!!
Any help would be great.