Select by Month of a field

by

Simply use MONTH() and YEAR():

SELECT * FROM Project WHERE MONTH(DueDate) = 1 AND YEAR(DueDate) = 2010

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. MySQL string replace
  4. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  5. Compare two MySQL databases [closed]
  6. MySQL – Trigger for updating same table after insert
  7. How do I get the current time zone of MySQL?
  8. How to get the difference in years from two different dates?
  9. Mysql Convert Column to row (Pivot table )
  10. MySQL grant all privileges to database except one table
  11. Writing optional parameters within stored procedures in MySQL? [duplicate]
  12. How to get all columns’ names for all the tables in MySQL?
  13. How do I get MySQL to use an INDEX for view query?
  14. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  15. Restore the mysql database from .frm files
  16. Mysql insert random datetime in a given datetime range
  17. How to get number of rows affected, while executing MySQL query from bash?
  18. Greatest value of multiple columns with column name?
  19. insert data from one table to another in mysql
  20. MySQL UPDATE syntax with multiple tables using WHERE clause
  21. How does MySQL Auto Increment work?
  22. MySQL load data infile – acceleration?
  23. mysql – Dynamic column alias
  24. MySQL Fulltext Search Score Explained
  25. Mysql performance on 6 million row table
  26. How can I “select *” from a table in MySQL but omit certain columns?
  27. For homebrew mysql installs, where’s my.cnf?
  28. MySQL Select Multiple VALUES
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment