how to update a field with metacharacter inside the str?
update table set f1='some=\'asdfsadf\' ' where id=1;
but the above sql statement won't work,
i know i can update f1 correctly if i set some='asdfsadf' to a variable and use that variable in the sql statemet. but i want to know if i can set that in the sql statement..