http://qs1969.pair.com?node_id=319089


in reply to deleting from a mysql database

DELETE FROM table WHERE Name ! IN ( 'a', 'b', 'c' )

cheers

tachyon

Replies are listed 'Best First'.
Re: Re: deleting from a mysql database
by exussum0 (Vicar) on Jan 06, 2004 at 13:02 UTC
    Becareful /w large IN statements... they can slow down DB's if nested and/or are large.

    Update: they lack indexes, so where's on them can be quite slow.


    Play that funky music white boy..
[reply]

In Section Seekers of Perl Wisdom