Return to Snippet

Revision: 35357
at November 5, 2010 23:52 by howardpanton


Initial Code
SELECT *
FROM 'table_name'
WHERE year ('date_field')
BETWEEN 2005
AND 2010

To delete all entries use this query

DELETE *
FROM 'table_name'
WHERE year ('date_field')
BETWEEN 2005
AND 2010

Initial URL


Initial Description
Use this to select all fields between two different dates

Initial Title
SELECT ALL => MySQL Database

Initial Tags
mysql

Initial Language
MySQL