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 "要匹配的字符$";