Use Following code
1. SELECT YEAR(now())
2. SELECT *
FROM table_name
WHERE YEAR( start_date
) LIKE ‘2007’
LIMIT 0 , 30
1. SELECT YEAR(now())
2. SELECT *
FROM table_name
WHERE YEAR( start_date
) LIKE ‘2007’
LIMIT 0 , 30