[SOLVED] Deleting From Table

[supanoob]

OK so i have an "Inventory System" and i need to delete say 100 rows of the same item belonging to the same person. How would this be possible? So for example it is set out like this:

 

 

[tr]

[td]Inventory ID

Item Id

Belongs to ID

1

12

1

1

12

1

 

but that data was like 157 times, how would i go about deleting 100 of those rows?

[papaface]

DELETE FROM `TABLENAME`WHERE `Item Id` = '12' AND `Belongs to ID` = '1'

should work.

[supanoob]

but how would i limit how many it deletes? i only want 100 of them gone not all of them if it is over 100.

[papaface]

try adding:

LIMIT 0,100

to the end, it may work.

[supanoob]

ill give that a go thanks.