Using PHP, I have a simple database that may store multiple items with the same content. I want to delete the first occurrence of an instance when I use DELETE.
How do you enable LIMIT for DELETE in SQLite using PHP?
DELETE FROM table WHERE rowid = (SELECT rowid FROM table WHERE condition LIMIT 1 )