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 '';