MySql查询
基本数据查询
全表查询
select * from tableName;
查询部分字段
select Field from tableName;
计数1
select count(*) from tableName;
计数2
select count(1) from tableName;
条件过滤
and (并且)
select * from tableName where 条件1 and 条件2;
or(或者)
select * from tableName where 条件1 or 条件2;
in(包含)
select * from tableName where Field in(value1,value2);
between ··· and ···(范围检查)
select * from tableName where Field between a and b;
not (否定结果)
select * from tableName where Field not in(value1,value2);
select * from tableName where Field not between a and b;
%(匹配任意字符)
select * from tableName where Field like "要匹配的字符%";
^(匹配以···开头的字符)
select * from tableName where Field rlike "^要匹配的字符";
$(匹配以···结尾的字符)
select * from tableName where Field rlike "要匹配的字符$";
标签:字符,匹配,tableName,Field,MySql,where,select From: https://www.cnblogs.com/cch6842/p/16620906.html