A MySQL question
| From: | zavaboy | Date: | Mon, 14 Jul 2003 21:13:24 +0000 |
| Subject: | A MySQL question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-155176@lists.php.net to get a copy of this message | ||
Ok, I want to delete only 1 row off of a database table...
Example:
I have a table with columns "user" and "item"...
Lets say the table contains the following rows (user | item):
582-668243 | Toothbrush
582-668243 | Toothbrush
582-668243 | Toothbrush
582-668243 | Trash can
582-668243 | Trash can
582-668243 | Something else
582-668243 | Something else
582-668243 | Something else
582-668243 | Something else
720-387690 | Dog treats
720-387690 | Car
720-387690 | Car
720-387690 | Toothbrush
720-387690 | Toothbrush
Ok, user 582-668243 is buying a lot, eh? LoL
Anyway, how can I remove only 1 Toothbrush from user 582-668243?
I just want the query... I've been trying to find it out for a few hours
now...
Thanks in advance!
--
- Zavaboy
zavaboy@hotmail.com
www.zavaboy.com