how to select data in mysql using year?

By Ikhlaque Maner November 11, 2011 My SQL

Use Following code

1. SELECT YEAR(now())

2. SELECT *
FROM table_name
WHERE YEAR( start_date ) LIKE ‘2007’
LIMIT 0 , 30

Post Views: 10