匹配以"%7"这个字符串开头 SELECT * FROM TABLE WHERE COL like '\%7%' escape '\' 后面escape '\'不可省
这里转义字符是自己定义的,如果字串中包含'\'的话,可以用其他字符代替 SELECT * FROM TABLE WHERE COL like '#%7%' escape '#'
SQL> select * from tt where name like '%\%7%' escape '\';NAME COUNT ---------- ---------- aaa%7bbb已用时间: 00: 00: 00.50 SQL> select * from tt where name like '%-%7%' escape '-';NAME COUNT ---------- ---------- aaa%7bbb已用时间: 00: 00: 00.40 SQL> select * from tt where name like '%!%7%' escape '!';NAME COUNT ---------- ---------- aaa%7bbb已用时间: 00: 00: 00.70 SQL> 但 转义符 最好还是用 \
SELECT * FROM TABLE WHERE COL like '\%7%' escape '\'
后面escape '\'不可省
SELECT * FROM TABLE WHERE COL like '#%7%' escape '#'
---------- ----------
aaa%7bbb已用时间: 00: 00: 00.50
SQL> select * from tt where name like '%-%7%' escape '-';NAME COUNT
---------- ----------
aaa%7bbb已用时间: 00: 00: 00.40
SQL> select * from tt where name like '%!%7%' escape '!';NAME COUNT
---------- ----------
aaa%7bbb已用时间: 00: 00: 00.70
SQL>
但 转义符 最好还是用 \