not equal statement only works with != not with <>
according to this bug report
It looks like the DBAL Parser cannot handle <> in the WHERE clause if I use != it works fine.
if <> is standard SQL I think this should be added to the SQL Parser of DBAL.
Updated by Stefan Neufeind almost 12 years ago
this would need to become "under review". (afaik doesn't happen automatically for the dbal-subproject; fix in core though ...)
I expect it would fix the DBAL-issue here, since DBAL extends from the t3lib-sqlparser, but unfortunately currently can't test against DBAL.