[RESOLVED] Wildcard Blues (mixing LIKE and NOT LIKE)

[Joseph_Sliker]

Hi;

Suppose I have a table that includes a bunch of values like so:

PHASE SCORE
D015 36
D045 34
D045 72
D085 64
DPM 44
F015 44
F045 34
F085 181
FPM 66

I want to do a MySQL query to just give me all "F" phase values EXCEPT the ones that say FPM:

Like so (desired response set)

F015 44
F045 34
F085 181

I've tried stuff like "SELECT * FROM tablename WHERE PHASE LIKE 'F%' and NOT LIKE 'FPM' ORDER BY SCORE"

... but that does not seem to work. I'm working with the 3.23 era version of MySQL that does not support subqueries.

Any suggestion?

Thanks

[mtmosier]

SELECT * FROM tablename WHERE PHASE LIKE 'F%' and NOT LIKE 'FPM' ORDER BY SCORE

You can't use just "and not like", and expect it to refer to the previous column referenced. You have to explicitly name the column again. Also you missed a % in your second like.

[Joseph_Sliker]

Thanks! (only 8 years later...shame on me!)