<div>
Delete from ADS <br />
where period_diff(NOW(),AdsDate)<wbr /> &gt;&nbsp;12) &nbsp;(MainCategory = 4 or MainCategory = 5 or MainCategory = 6)
</div>


Delete from ADS
where period_diff(NOW(),AdsDate) > 12)  (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)

<div>
it deleted all my data<br />
<br />
Delete from ADS <br />
where (period_diff(NOW(),AdsDate<wbr />) &gt;&nbsp;12) and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6) 
</div>


it deleted all my data

Delete from ADS
where (period_diff(NOW(),AdsDate) > 12) and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)

<div>
I only want to delete the date calculated from today's date up to 12 months
</div>


I only want to delete the date calculated from today's date up to 12 months

<div>
Cluskitt:<br />
<br />
GREAT!!
</div>


<div>
Try this and let me know if it helped :<br />
<br />
Delete from ADS<br />
where months_between (to_date (NOW(), 'yyyy/mm/dd'), to_date (AdsDate, 'yyyy/mm/dd') ) &gt;&nbsp;12<br />
and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)
</div>


Try this and let me know if it helped :

Delete from ADS
where months_between (to_date (NOW(), 'yyyy/mm/dd'), to_date (AdsDate, 'yyyy/mm/dd') ) > 12
and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)

<div>
oops ...sorry.. my bad.. Hope you are not doing it directly on production.. <br />
<br />
<br />
<br />
Delete from ADS <br />
where date_add(AdsDate, interval 12 Month)&lt;Now() &nbsp;and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)<br />

</div>


oops ...sorry.. my bad.. Hope you are not doing it directly on production..



Delete from ADS
where date_add(AdsDate, interval 12 Month)<Now()  and (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)


<div>
while Cluskitt solution will work for most of the cases.. you may find it delete 1st of january record in a leap year due to 366 days in leap year.. 
</div>


while Cluskitt solution will work for most of the cases.. you may find it delete 1st of january record in a leap year due to 366 days in leap year..

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I would like to delete records that have been in the database more than 12 months.<br />
<br />
Delete from ADS <br />
where datediff(NOW(),AdsDate) &gt;&nbsp;twelve months?) &nbsp;(MainCategory = 4 or MainCategory = 5 or MainCategory = 6)
</div>
</div>


Hi,

I would like to delete records that have been in the database more than 12 months.

Delete from ADS 
where datediff(NOW(),AdsDate) > twelve months?)  (MainCategory = 4 or MainCategory = 5 or MainCategory = 6)

Delete query

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.