Compare only day and month with date field in mysql

by

Use DATE_FORMAT instead:

SELECT DATE_FORMAT('2000-07-10','%m-%d')

yields

07-10

Here’s your query re-written with DATE_FORMAT():

SELECT *
FROM table
WHERE DATE_FORMAT(field, '%m-%d') = DATE_FORMAT('2000-07-10', '%m-%d')
AND id = "1"

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. SQL query return data from multiple tables
  4. Left Outer Join doesn’t return all rows from my left table?
  5. Get a list of dates between two dates
  6. How to populate a table with a range of dates?
  7. MySQL Query GROUP BY day / month / year
  8. MySQL SELECT only not null values
  9. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  10. MySQL Query – Records between Today and Last 30 Days
  11. Ordering by specific field value first
  12. Difference between two dates in MySQL
  13. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  14. Select mysql query between date?
  15. Get the latest date from grouped MySQL data
  16. Checking multiple columns for one value
  17. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  18. How to select the most recent set of dated records from a mysql table
  19. MySQL INSERT INTO … VALUES and SELECT
  20. How to select one row randomly taking into account a weight?
  21. quick selection of a random row from a large table in mysql
  22. Syntax error when using except in a query
  23. SELECT query return 1 row from each group
  24. MySQL INNER JOIN select only one row from second table
  25. MySQL Select Query – Get only first 10 characters of a value
  26. SQL query to check if a name begins and ends with a vowel
  27. Insert/ Update random date in MySQL
  28. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  29. How to SELECT by MAX(date)?
  30. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

Leave a Comment