oracle中如何搜索 % ?

oracle中如何搜索 % ?
一表如下:
aaa%ggg
df%k
%mjg
jhdkfjg%
ikkkl
...

如何搜索该字段中的 % ?
谢谢
---------------------------------------------------------------

To search for employees with the pattern 'A_B' in their name:

SELECT last_name
FROM employees
WHERE last_name LIKE '%A\_B%' ESCAPE '';

so, you can

select * from yourtab where yourcol like '%%%' ESCAPE '';

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus