mysql学习记录

mysql 排序

select core from table order by;    升序

select core from table order by core desc;    降序

select core from table where core between 5 and 10;    where求core介于5和10之间的所有值，包括指定的开始值和结束值。

select name from table where core is null;     检查空值

select request_id,name from ods_senseid_third_party_v2_wj where name regexp "MD." limit 5;   regexp 后面跟着正则表达式

select request_id,name from ods_senseid_third_party_v2_wj where request_id like "%178" limit 2;   like 跟着通配符 %模糊匹配，  _单个匹配