Re: [ic] Re: how to remove records from database

[Dan B <db@cyclonehq.dnsalias.net>]

At 03:35 AM 6/30/2001 +0000, you wrote:
>this command works
>delete from merchandising where sku = "os28004";
>and so on, you have to list them one by one,
>"os*"; doesn't pickup all the names that start with os,
>why not ?

I highly recommend that you join a Mysql or any SQL mailing list.

The MySQL lists are great, you'll probably get a response if you post 
there.  The address is something like:
         mysql-subscribe@lists.mysql.com
But I can't recall for sure.

BUT, you should be able to use some kind of command like:

DELETE FROM merchandising WHERE sku LIKE "os%";

HTH,

Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com