Select a year from datetime

[marf]

This should be fairly simple I think. I want to perform basically this

 

SELECT * FROM database WHERE date='2006-00-00 00:00:00'

 

Will this work? I want to select all the entries where the year is 2006. I'm not sure if this will specifically look for 2006-00-00 00:00:00.. logically to me I would want date='2006-XX-XX XX:XX:XX'  but SQL doesn't like that of course.

 

 

[jvrothjr]

could use where date like '2006%'

[akitchin]

you could extract the date's year using YEAR(), a handy built-in MySQL function among others:

 

SELECT * FROM database WHERE YEAR(date)='2006'

 

more efficient and less prone to odd behaviour than using LIKE.