Thanks Andy,
One more thing in that same field some values are FALSE. If I want to replace FALSE with nothing could I also use this statement:
UPDATE allcards SET isred = REPLACE(isred,"FALSE","") WHERE isred LIKE '%FALSE%'
One more thing in that same field some values are FALSE. If I want to replace FALSE with nothing could I also use this statement:
UPDATE allcards SET isred = REPLACE(isred,"FALSE","") WHERE isred LIKE '%FALSE%'