Re: Selected items delete

[gerald_clark]

Delete from table where num in ( 1,13,34) ;

Pag wrote:

    Hi,

    I am kinda new to this mysql thing, so please forgive the basic 
question.
    What i need to do is, list my records on a table with a checkbox 
for each. After we choose several of the records, we click a button 
and i want to be able to delete the ones selected. Is there a simple 
mysql command that could perform this? I can do all the html/form/php 
list things, but the mysql is out of my grasp. :-P
    If i was too confusing, maybe this helps: How can i delete the 
records whose "num" field is 4,78,34 and 23, all in one command? 
Something along "delete * in 'table' where num=1 and num=13 and 
num=34" etc.

    Thanks a lot.

    Pag





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]