How to search by Year

[j3ss1ca]

how do i find a specific date? i typed this in and it didnt work

SELECT Category, ScreenSize, Title, Classification, MovieNo    
from c_movie,c_cinema
where category = 'Comedy' and ScreenSize = 's'
where Year in '2009-%-%'

[chathura86]

i assume that you have a column named Year which has dates and
you want to select records for a specific year.

well mysql has a function year() which returns the year from a date

eg

SELECT YEAR('2010-03-31');
returns 2010,

so you can use that to filter from a year

SELECT Category, ScreenSize, Title, Classification, MovieNo
from c_movie,c_cinema
where category = 'Comedy' and ScreenSize = 's'
and year(Year) in ('2009')
 

Regards