(Android: sqlite 3) query data with wildcards in an SQL statement, such as an underscore (_).

# % Represents any number of characters

Select*FromUserWhereUsername like '% huxiao ';

Select*FromUserWhereUsername like 'huxiao % ';

Select*FromUserWhereUsername like '% huxiao % ';

# _ Represents a character

Select*FromUserWhereUsername like '_';

Select*FromUserWhereUsername like '______';

Select*FromUserWhereUsername like 'huxia _';

Select*FromUserWhereUsername like 'H _ xiao ';

 

# What if I want to check % or? UseEscapeThe % or _ after the escape character is not used as a wildcard. Note that the % and _ without the escape character are still used as wildcards.

SelectUsernameFromGg_userWhereUsername like '% xiao \ _ %'Escape'\';

SelectUsernameFromGg_userWhereUsername like '% xiao \ %'Escape'\';

 

'\' Is usually used for escape characters, but other symbols can also be used.