"OR" not working in MYSQL SQL

[camarosource]

What am I doing wrong?

"SELECT SUBMISSION_ID, FULL_NAME, EMAIL, CAMARO_YEAR, CAMARO_MODEL, SAID_TO_PURCHASE,
ACTUALLY_PURCHASED, WERE_PICS_UPLOADED, EMAILED_NO_PICS_SENT, ADMIN_COMMENTS, GALLERY_CREATED, EMAILED_NO_GALLERY,
WERE_PICS_GOOD_ENOUGH, EMAILED_PICS_NOT_GOOD FROM user_submissions WHERE WERE_PICS_UPLOADED = 'YES'
AND WERE_PICS_GOOD_ENOUGH = 'NO' OR WERE_PICS_GOOD_ENOUGH = ' ' ORDER BY SUBMISSION_ID";

I want to do the following

• Select those tables from the user_submissions database WHERE WERE_PICS_UPLOADED = 'YES'. It would ONLY select those tables if the WERE_PICS_GOOD_ENOUGH field = 'NO' OR WERE_PICS_GOOD_ENOUGH = a BLANK entry..

What's wrong?

It seems to select the "WERE_PICS_UPLOADED = 'YES'" is not being read as it will select all those tables EVEN if the WERE_PICS_UPLOADED = is NOT "YES".

If I make it.

"SELECT SUBMISSION_ID, FULL_NAME, EMAIL, CAMARO_YEAR, CAMARO_MODEL, SAID_TO_PURCHASE,
ACTUALLY_PURCHASED, WERE_PICS_UPLOADED, EMAILED_NO_PICS_SENT, ADMIN_COMMENTS, GALLERY_CREATED, EMAILED_NO_GALLERY,
WERE_PICS_GOOD_ENOUGH, EMAILED_PICS_NOT_GOOD FROM user_submissions WHERE WERE_PICS_UPLOADED = 'YES'
AND WERE_PICS_GOOD_ENOUGH = 'NO' ORDER BY SUBMISSION_ID";

(removing "OR WERE_PICS_GOOD_ENOUGH = ' ' ") t then it WON'T select the tables for those where "WERE_PICS_GOOD_ENOUGH" is BLANK.

[laserlight]

OR has a lower precedence than AND, so you should group:

WHERE WERE_PICS_UPLOADED = 'YES'
AND (WERE_PICS_GOOD_ENOUGH = 'NO' OR WERE_PICS_GOOD_ENOUGH = ' ') ORDER BY SUBMISSION_ID

Of course, if you want to compare with NULL instead of a string with a single space, you should write OR WERE_PICS_GOOD_ENOUGH IS NULL.