advanced code snippet search

Posted By

howardpanton on 11/05/10


Tagged

mysql


Versions (?)

SELECT ALL => MySQL Database

 / Published in: MySQL
 

Use this to select all fields between two different dates

Expand | Embed | Plain Text 
  1. SELECT *
  2. FROM 'table_name'
  3. WHERE YEAR ('date_field')
  4. BETWEEN 2005
  5. AND 2010
  6.  
  7. To DELETE all entries USE this query
  8.  
  9. DELETE *
  10. FROM 'table_name'
  11. WHERE YEAR ('date_field')
  12. BETWEEN 2005
  13. AND 2010

Report this snippet  

You need to login to post a comment.