have you any sql query,which remove my 2 month old links ....

Hello Every one...

I am running one large database site. suddenly my sql loads highly on server, and two-three times, my host have suspend me. now I wanted to delete my old links which are more then 2 month...I am very thank full if any sql master or php coder can give me that type of query...

 

Can you post the structure of the table?

 

It would be something like:

DELETE FROM my_table WHERE date_column <= DATE_SUB(NOW(), INTERVAL 2 MONTHS);

 

I have included here image of my table structure..........please look at this and give your answer.....

 

Delete From pligg_links Where link_published_date < Date_Sub(Curdate(), Interval 2 Months);