Oracle like fuzzy query

LIKE fuzzy query

The wildcard characters "%" and "_" can be used for character matching:

%: Represents any character, including zero;

_: Represents any character;

1. ConnectedToOracleDatabase11g Enterprise Edition Release 11.2.0.1.0
2. ConnectedAsScott
4. SQL>Select*FromDept;
6. DEPTNO DNAME LOC
7. ---------------------------------
8. 10 ACCOUNTING NEW YORK
9. 20 RESEARCH DALLAS
10. 30 SALES CHICAGO
11. 40 OPERATIONS BOSTON

"%" And "_" Demo:

1. SQL>Select*FromDeptWhereDNAMELike '_ A %';
3. DEPTNO DNAME LOC
4. ---------------------------------
5. 30 SALES CHICAGO

ESCAPE Demo:

1. SQL>Insert IntoDeptValues(50,'Beijing','Jiang % Xi');
3. 1 row inserted
5. SQL>Select*FromDept;
7. DEPTNO DNAME LOC
8. ---------------------------------
9. 10 ACCOUNTING NEW YORK
10. 20 RESEARCH DALLAS
11. 30 SALES CHICAGO
12. 40 OPERATIONS BOSTON
13. 50 beijing jiang % XI
15. SQL>Select*FromDeptWhereLocLike '% \ %' Escape '\';
17. DEPTNO DNAME LOC
18. ---------------------------------
19. 50 beijing jiang % XI
21. SQL>Select*FromDeptWhereLocLike '% E %' Escape 'E';
23. DEPTNO DNAME LOC
24. ---------------------------------
25. 50 beijing jiang % XI

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12