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 "要匹配的字符$";
原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/tech/database/282057.html