两种方式: 1)使用\进行转义,如:select * from employees where last_name like '_\_%'; 2)使用escpae声明转义字符:select * from employees where last_name like '_$_%' ESCAPE '$';,此时\不再作为转义字符,而只是一个普通字符
\
select * from employees where last_name like '_\_%';
escpae
select * from employees where last_name like '_$_%' ESCAPE '$';