Using the correct, or preferable, not equal operator in MySQL

<> should be preferred, all things being equal, since it accords with the sql standard and is technically more portable…

!= is non-standard, but most db’s implement it.

sql:2008 grammar:

<not equals operator> ::=
  <>