i want drop attachment from 1 to 999

[alamuae]

my vb Version 2.3.0
vb attachment 734.5 MB

i want drop attachment from 1 to 999

the fourm complete two years and i wana to delete the attachment of the first year
Is there any sql database command to do that ?
this command allow me to delete the attachment for a certain period of time

[Martin64]

Yes. Use this query:

DELETE from `attachment` where attachmentid < 999

[alamuae]

ok man
Thank You

[dubai2]

hello

i try this
DELETE from `attachment` where attachmentid < 999

but its not work corectly

can i find another query ???????????????

[filburt1]

BACK UP FIRST and try:

DELETE FROM attachment ORDER BY dateline ASC LIMIT 999;

Untested but should delete the 999 oldest attachments.