Advanced Search

SELECT ALL => MySQL Database

/ Published in: MySQL
Save to your folder(s)
Use this to select all fields between two different dates

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.