[Resolved] Will this query work??

[Napster]

As the title, says, will the following query work?

mysql_query("DELETE FROM table WHERE cat = '1' ORDER BY id LIMIT 1") or die(mysql_error());

I want to delete the oldest entry in the table which is in category 1. I do not want to run the code and delete my database.

[drew010]

delete doesnt allow order by, so your best bet is to issue one query to grab the oldest entry, and then delete it using the where clause which would be unique to something in that entry, maybe its id number or timestamp of when it was added.

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
       [WHERE where_definition]
       [ORDER BY ...]
       [LIMIT row_count]