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

-- "_" in this sql is a wildcard character that matches any single character, so the filtered data contains the data at the beginning of test:

Select * from live_class where title like 'test_%'

Solution:

-- the following two implementations have the same effect (personal preference for the second, which is more in line with the usage habits of background development):

Select * from live_class where title like 'test/_%' escape' /'; select * from live_class where title like 'test\ _%'

Note: the difference between "_" and "%" is that the wildcard "_" matches any single character, while "%" is any character.

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.