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

[Mark Johnson <markj@redhat.com>]

Raymond 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 ?
> 

It is not an '='. However, since you didn't post the query that didn't
work, I can only assume that's the problem.

delete from merchandising where sku LIKE "os%";

-- 
Mark Johnson
Senior Systems Architect - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912