查找一个字段是否包含所要查找的字符串,FIND_IN_SET(str,strs),str为要查找的字符串,strs为字段
select title from log where FIND_IN_SET('asp程序设计,php',title);
判断日期日段与当前日期相差多少天
select datetime,to_days(now())-to_days(datetime) from log order by datetime desc;
查找一个字段是否包含所要查找的字符串,FIND_IN_SET(str,strs),str为要查找的字符串,strs为字段
select title from log where FIND_IN_SET('asp程序设计,php',title);
判断日期日段与当前日期相差多少天
select datetime,to_days(now())-to_days(datetime) from log order by datetime desc;