[Koha-devel] SQL Query not equal and NULL
Fridolin SOMERS
fridolin.somers at biblibre.com
Thu Nov 5 15:36:28 CET 2020
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 at biblibre.com>
Software and system maintainer 🦄
BibLibre, France
More information about the Koha-devel
mailing list