查询字符串以xx开头
select * from user where nickname LIKE '易%';
查询字符串以xx结尾
select * from user where nickname LIKE '%联';
查询字符串包含xx
select * from user where nickname LIKE '%建%';
查询字符串不包含xx
select * from user where nickname NOT LIKE '%建%';
查询字符串第一个字符之后是xx的数据
select * from user where nickname LIKE '_琦';
查询字符串以xx开头,以xx结尾
select * from user where nickname LIKE '易_联';