user1269625
Reputation: 3209
MySQL Where date is not equal to current year
I have this syntax here:
date_record != YEAR(CURDATE())
and all the record returned are have the year 2013...What am I doing wrong?
Upvotes: 0
Views: 1194
Answers (1)
Trudysfun
Reputation: 181
maybe just compare the years...
YEAR(date_record) != YEAR(CURDATE())
Upvotes: 2
Related Questions
- Get current year in MySQL WHERE clause
- Select between date range ignoring the year
- Ignoring the year in SQL Query with date range
- MYSQL Query Just Year from Date
- How to check if date is in range regardless of the year
- How to put the first date of this year in a WHERE clause. MYSQL
- SQL: Where between two dates without year?
- SQL: Not a specific year
- how to query database for date = today, except... there is no year
- mysql query using date of year