how do I get month from date in mysql

by

You were close – got the comparison backwards (assuming startDate is a DATETIME or TIMESTAMP data type):

SELECT * 
  FROM table 
 WHERE amount > 1000 
   AND MONTH(dateStart) = {$m}

Caveats:

Alternatives:

Because using functions on columns can’t use indexes, a better approach would be to use BETWEEN and the STR_TO_DATE functions:

WHERE startdate BETWEEN STR_TO_DATE([start_date], [format]) 
                    AND STR_TO_DATE([end_date], [format])

See the documentation for formatting syntax.

Reference:

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. Using PHP data in MySQL [closed]
  3. How can create Database using url or other method [duplicate]
  4. Checking the availability of rooms
  5. Commands out of sync; you can’t run this command now
  6. SELECT COUNT(*) AS count – How to use this count
  7. Get table column names in MySQL?
  8. How to resolve ambiguous column names when retrieving results?
  9. Loading .sql files from within PHP
  10. selecting unique values from a column
  11. Use bound parameter multiple times
  12. I cannot get my login form to connect interact properly with mySQL database [closed]
  13. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  14. Increment value in MySQL update query
  15. Create a dynamic mysql query using php variables
  16. PHP: multiple SQL queries in one mysql_query statement
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. Do SQL connections opened with PDO in PHP have to be closed
  19. How to convert ISO8601 to Date format in php
  20. MySQL skipping first row
  21. How to reverse order output of a MySQL query
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. How to generate unique id in MySQL?
  24. How to SELECT DEFAULT value of a field
  25. Fatal error: Call to a member function query() on null
  26. How would I implement a simple site search with php and mySQL?
  27. Do I have to use mysql_real_escape_string if I bind parameters?
  28. PDO and MySQL ‘between’
  29. MySQL Join Multiple Rows as Columns
  30. Aggregated query without GROUP BY

Leave a Comment