Posts: 680
Threads: 143
Joined: Nov 2014
Reputation:
0
How to check if fields equal null, I've enabled it to be null in the database. But how to check if it is null or not because in some cases it may handle data.
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Altering the query to handle such cases is probably the easiest, you can use IFNULL() for that. It can be handled in Pawn as well, but I don't think it's as neat because it requires string comparison which is very slow.