各位高手，求一条SQL语句？？急！！

Question

select * from table where year(riq)=2004 and month(riq)=4 and day(riq)=25不知道行不行.. 我不是很懂.. 呵呵

Answer 1

select * from table where DATE_FORMAT(riq,'%Y-%m-%d') = '2004-4-25'

Answer 2

select * from table where TO_DAYS(RiQ) = TO_DAYS('2004-4-25');

Answer 3

select * from table where TO_DAYS(RiQ) = TO_DAYS('2004-04-25');月份必须写成这样“2004-04-25”

Answer 4

select * from table where DATE_FORMAT(RiQ,'%Y-%c-%e')=DATE_FORMAT('2004-4-25','%Y-%c-%e')