How do I extract Month and Year in a MySQL date and compare them?

by

in Mysql Doku:
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_extract

SELECT EXTRACT( YEAR_MONTH FROM `date` ) 
FROM `Table` WHERE Condition = 'Condition';

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. Get a list of dates between two dates
  3. How to populate a table with a range of dates?
  4. MySQL Query GROUP BY day / month / year
  5. Error in MySQL when setting default value for DATE or DATETIME
  6. Difference between two dates in MySQL
  7. Get the latest date from grouped MySQL data
  8. How to select the most recent set of dated records from a mysql table
  9. Compare only day and month with date field in mysql
  10. Insert/ Update random date in MySQL
  11. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  12. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  13. SQL Query needed for fetch value from Two identical table but not fully identical table
  14. SQL select only rows with max value on a column [duplicate]
  15. How to create a MySQL hierarchical recursive query?
  16. How to reset AUTO_INCREMENT in MySQL
  17. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  18. SQL counting all rows instead of counting individual rows
  19. Combining UNION and LIMIT operations in MySQL query
  20. MySQL comparison with null value
  21. MySQL Like multiple values
  22. Matching all values in IN clause
  23. MySQL add days to a date
  24. INTERSECT in MySQL
  25. Check for x consecutive days – given timestamps in database
  26. How do I get the ID of multiple inserted rows in MySQL?
  27. How to alter a column and change the default value?
  28. sql join tables where 1 column has comma
  29. Remove special characters from a database field
  30. update a column by subtracting a value

Leave a Comment