I need to update a row in my column like
update my_table SET column_name = 'vector = 1 AND value IN('A','B','C')'This does not work and I am not sure how I can write the SQL so the =(sign) is ignored.I basically need it to be accepted as a text string to be updated.
Just to be clear; vector = 1 AND value IN('A','B') is the existing value in my row I want to update to vector = 1 AND value IN('A','B','C')
أكثر...
update my_table SET column_name = 'vector = 1 AND value IN('A','B','C')'This does not work and I am not sure how I can write the SQL so the =(sign) is ignored.I basically need it to be accepted as a text string to be updated.
Just to be clear; vector = 1 AND value IN('A','B') is the existing value in my row I want to update to vector = 1 AND value IN('A','B','C')
أكثر...