MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Simple Delete Query
Posted by: Rick James
Date: April 24, 2014 08:23PM

Date >= '2013-01-01'
AND
Date < '2013-01-01' + INTERVAL 1 YEAR

You may need to use CONCAT or some other tool to turn 2013 into '2013-01-01'.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Simple Delete Query
Ricco Semento
April 22, 2014 08:17AM
Re: Simple Delete Query
Keith Larson
April 22, 2014 07:12PM
Re: Simple Delete Query
Rick James
April 22, 2014 09:23PM
Re: Simple Delete Query
Ricco Semento
April 24, 2014 06:36AM
Re: Simple Delete Query
Ricco Semento
April 24, 2014 06:38AM
Re: Simple Delete Query
Ricco Semento
April 24, 2014 07:36AM
Re: Simple Delete Query
Rick James
April 24, 2014 08:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.