Field equals null
#1

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.
Reply
#2

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.
Reply
#3

So, will IFNULL works in samp. And if yes, Should I retrive the data and store it in the string then do
PHP код:
if(IFNULL(string)) 
OR?
Reply
#4

Searching the term on ****** is such an incredibly hard job, indeed. https://dev.mysql.com/doc/refman/5.0...unction_ifnull
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)