MySQL Syntax Error: Escaping Single Quotes in SQL Update Statements

The error in the SQL syntax is caused by the use of single quotes within the value of the update statement. To correct the error, the single quotes within the value should be escaped using a backslash () or by using double quotes to wrap the value. Here is the corrected SQL statement:

UPDATE settings_setting SET value = '["59.56.77.106/32", "59.56.77.107/32", "172.16.0.0/16", "192.168.0.0/16", "154.82.111.0/24", "154.82.84.0/24"]' WHERE name = 'SECURITY_LOGIN_IP_WHITE_LIST';