MySQL 随记

判断某个字段长度方法sql:

SELECT * FROM users WHERE  length(login_name)>25 AND flag!=-1 

去重关键字：

DISTINCT

if语句使用：

select count(*),count(*)/14314,
if(if(ROUND((new_assess-money)/money,2)>1,"大于1",ROUND((new_assess-money)/money,2))>0.3,'30%',if(ROUND((new_assess-money)/money,2)>1,"大于1",ROUND((new_assess-money)/money,2))) as rou
from assess_price where money !='0.0' AND modified_time>='2019-02-21'
group by rou order by rou

MySQL类型转换 使用CAST将varchar转换成int类型排序

as SIGNED

replace 替换函数

UPDATE car_type set `subject` = replace(`subject`,'2019款 ','') where flag=1 AND `subject` LIKE "%款%"

转载于:https://www.cnblogs.com/devin-sl/p/11132925.html