Skip to content
Advertisement

SQLI Query not Updating NULL

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;
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement