select 'I have a \' in my value' from dual;
select REPLACE("I have a ' in my value",'''','''''') from dual;
select CONCAT('INSERT INTO r_job(id_job,VALUE_STR) VALUES (',123,',\'',REPLACE("I have a ' in my value",'''',''''''),'\');') from dual;
select CONCAT('INSERT INTO r_job(id_job,VALUE_STR) VALUES (',123,',\'',REPLACE(IFNULL("I have a ' in my value",''),'''',''''''),'\');') from dual;
两个单引号''表示一个单引号,所以只要将一个单引号替换成两个单引号即可