官术网_书友最值得收藏!

LIKE

The LIKE operator provides an easy way to search records with the different patterns in a column. We can use wildcards characters in a query to build various patterns. There are basically two kinds of wildcard which are mostly use. Let's see each of them with the example.

  • % (Percentage): Use this wildcard to search zero or more occurrences of any character. Suppose if we want to search users whose username starts with 'a' then we can use this wildcard just like below query.
select * from users where username like 'a%';

In case where we want to search users whose username starts from 'a' and ends with 's' then the query with % wildcard will be like this.

select * from user where username like 'a%s';
  • _ (Underscore): Use this wildcard where we want to search records with the pattern where any character can take place where we have specified underscore (_). Suppose we want to search users whose username ends with dmin and we are not sure about the first character. Hence below query will search results whose username's first character can be any but it should end with dmin.
select * from users where username like '_dmin';

Make sure that it would consider exactly one character for one underscore. Hence in this case user with username as "aadmin" will not be considered because query has mentioned only one wildcard character with the underscore.

主站蜘蛛池模板: 永春县| 新乡县| 布尔津县| 南召县| 安平县| 定边县| 栾川县| 麻城市| 北票市| 万盛区| 定南县| 万全县| 大埔县| 镇坪县| 宜兰市| 闽清县| 元阳县| 井陉县| 娄烦县| 永寿县| 高清| 高淳县| 永顺县| 福泉市| 子长县| 清镇市| 剑河县| 如皋市| 斗六市| 乌恰县| 车致| 定边县| 德安县| 赣榆县| 上林县| 盐边县| 弋阳县| 阿拉尔市| 葵青区| 宕昌县| 南安市|