NYCPHP Meetup

What's wrong with this query.

Nasir Zubair nasir at nasir.us
Wed Mar 12 19:34:45 EST 2003


Hi all,

Can anyone point out what is wrong with this query:

DELETE FROM `nsr_staffips` WHERE `tech` LIKE 'Nasir' ORDER BY `timestamp`
LIMIT 1 

According to mySQL manual it should delete the oldest entry ordered by the
timestamp filed.

- Nasir




More information about the talk mailing list