オラクルのファジー・クエリーとその使い方

SELECT * FROM [user] WHERE uname LIKE '%three%' 
// search results: "Zhang San", "Xiao San", "three-legged cat", "cat three-legged" with Find all the records with "three". 
SELECT * FROM [user] WHERE uname LIKE '%three' (match from the back) 
//search results: "Zhang San", "Xiao San" 
// Also, if you need to find a record with both "three" and "cat" in uname, use the and condition 
SELECT *FROM [user] WHERE uname LIKE '%three%' AND uname LIKE '%cat%' 
If you use SELECT * FROM [user] WHERE uname LIKE '%three%cat%'// you can search for "three-legged cat", but not "cat three-legged".

SELECT * FROM [user] WHERE uname LIKE 'three' 
// search result: "cat three feet" such that uname is three characters and the middle one is "three". 
SELECT * FROM [user] WHERE uname LIKE 'three__'; 
//search results: "three-legged cat" where uname is three characters and the first one is "three".

SELECT * FROM [user] WHERE u_name LIKE '[张李王]三' 
//search results: "Zhang San", "Li San", "Wang San" (instead of "Zhang Li Wang San"). 
// if [ ] has a series of characters (01234, abcde, etc.) can be abbreviated to "0-4", "a-e" 
SELECT * FROM [user] WHERE u_name LIKE 'old [1-9]' 
// search results: "old 1", "old 2", ......, "old 9".

SELECT * FROM [user] WHEREinstr(uname ,'three')>0 

select id, namefrom user where instr('101914, 104703', id) > 0; 

select id, namefrom user where id = 101914 or id = 104703;