Dan Ciborowski - MSFT Dan Ciborowski - MSFT - 1 year ago 77
MySQL Question

SQL: How to perform string does not equal

I have the following query

WHERE tester <> 'username';

I am expecting this to return all the results where tester is not the string
, But this not working. I think I am looking for the inverse of the
operator but I am not sure? In my searches I have found solutions for numbers (that's where i got <> from), but this seems to not be working with strings.

Answer Source

Your where clause will return all rows where tester does not match username AND where tester is not null.

If you want to include NULLs, try:

where tester <> 'username' or tester is null

If you are looking for strings that do not contain the word "username" as a substring, then like can be used:

where tester not like '%username%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download