摘要:
locate(substr,str) 查找substr在str中第一次出现的位置,为空时返回0 SELECT login_name, LOCATE('ning',login_name) FROM user WHERE `login_name` ='liangningning'; locate(sub 阅读全文
摘要:
保留两位小数 SELECT ROUND( 123456789.3563898,2),TRUNCATE(123456789.3563898,2),FORMAT(123456789.3563898,2); 类型转换函数 convert()和cast() CAST(value as type); CONV 阅读全文