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:

[sql]DELETE from `attachment` where attachmentid < 999[/sql]

[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:
[sql]
DELETE FROM attachment ORDER BY dateline ASC LIMIT 999;
[/sql]
Untested but should delete the 999 oldest attachments.