[RESOLVED] SELECT everything but column1='A' AND column1='B'

[curb]

How do I select every row except column1 containing "A" or "B"?

[laserlight]

Looks like you pretty much got it right. It would be something along the lines of:

SELECT * FROM tablename WHERE column1<>'A' AND column1<>'B'

[curb]

Thanks lasterlight. Is there any references for <> and any other symbols that would modify the query?

[laserlight]

<> is the same as != (not equal comparison), but from what I understand, <> is standard usage in SQL as opposed to !=.