[Koha-devel] SQL Query not equal and NULL

Hi, From : https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24379#c1

This query does not return rows where login_attempts IS NULL. It will return accounts where login_attempts = 0

I only recently understood the behavior or NULL values in SQL queries for NOT IN and !=. Should be advice this in coding guide lines ? Is there a syntax better than another : col!=value / not(col=value) ? Best regards 🎃 -- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France