I am having a problem with updating a NULL value in SQLI.
SELECT * FROM sqli_information; UPDATE sqli_information SET optional_security_question = "Not Available" WHERE optional_security_question = NULL;
There are no errors but it just stays at null. I am trying to get every NULL
value in the optional_security_question
and turn it into Not Available
instead.
Advertisement
Answer
Try to use this syntax:
UPDATE sqli_information SET optional_security_question = "Not Available" WHERE optional_security_question IS NULL;