表 x
时间字段 y
怎么给y (格式:2008-12-9)加上一年?
变成(2009-12-9)
update x set y=dateadd(year,1,y)
在时间字段上拿出年份
效率比较低的做法:
$sql = "select * from news where date like '2008%' order by id desc";
可能效率高点的(没测试过):
$sql = "select * from news where YEAR(date) = 2008 order by id desc";
不能用是因为你的date字段不是time类型的。
$sql = "select * from news where left(date,4)='2008' order by id desc";
$sql = "select * from news where date_format(date, '%Y')='2008' order by id desc";