Oracle wildcard filtering (fuzzy matching)
(1) Like is used for wildcard filtering.
(2) the wildcard for single character matching is the half-width underscore "_", which matches a single character that appears, starting with any character, and the rest is "erry":
Select * from T_Employee where FName like'_ erry'
(3) the wildcard for multi-character matching is the half-corner percent sign "%", which matches any character that appears any number of times (zero or more), and "K%" matches a string of any length that begins with K. Retrieve information about employees whose names contain "n":
Select * from T_Employee where FName like'% n%'
Original address: http://bbs.delit.cn/thread-163-1-1.html
Please indicate the source of the reprint
Written by: measurement Technology http://www.delit.cn
