A MySQL question

From: 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

« previous php.general (#155176) next »