What is the difference between and != operators in MySQL? [duplicate]

<> 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> ::=
  <>