Shulou(Shulou.com)06/01 Report--

(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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.