In mysql you can, though your syntax is wrong.... Try changing "DELETE exre.*" to just "DELETE". Otherwise it thinks you are doing multiple-table syntax, which doesn't allow order by/limit.
See http://dev.mysql.com/doc/refman/5.1/en/delete.html Jon On Feb 28, 2011, at 9:49 AM, Steve Meyers wrote: > On 2/28/11 9:48 AM, Wade Preston Shearer wrote: >> "You have an error in your SQL syntax; check the manual… …near 'ORDER BY…" > > That's what I thought, I didn't think you could use ORDER BY in a DELETE. > > Steve > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
