SQL Delete query

[Renounce]

i am kinda stuck here.. i looked around on the internet for some tut's.. but i followed a few of them when the 3rd time failed "I Fail" i was done with it -.-
What i am looking for is a query where u can search for the Index 300 that delete's the whole row so people dont got their items in their inventory or storage anymore

as sample:

Table. dbo.item
Row. Index
Item Needs to find: lets say.. 300 or something
what's the correct query to delete all 300 indexes? (the whole row from PID to UpgrRate)

to lazy to searchin through all 100000 rows and find all 300 indexes..

Hope someone got a solution:)

[MentaL]

[TrueDarKZONE]

DELETE FROM [YOURDBNAME].[dbo].[Item]
WHERE [Index] = '300'

[Renounce]

thanks i will try it

[Momo5000]

http://www.w3schools.com/sql/default.asp

there u go :D

[hero322]

im pretty sure this should work...

<?php
mssql_connect('localhost') or die('mist');
mssql_select_db('kal_db') or die('kack');
DELETE FROM [YOURDBNAME].[dbo].[Item];
WHERE [Index] = '300';
?>
</table></center>
</body>
</html>