Re: [SQL] Wildcard LIKE and Sub-select

I took off the USING clause like so, and it worked like a charm!DELETE FROM keywordsWHERE keyword ILIKE ANY (SELECT '%' || badword || '%'                                                   FROM badwords) Thanks so much,TravisOn 11/10/06, Erik Jones < [EMAIL PROTECTED]> wrote: Travis Whitton wrote:>

Re: [SQL] Wildcard LIKE and Sub-select

Travis Whitton wrote: Hi everybody, I have two tables of the following structure: Table "keywords" column | type - id | integer keyword | varchar(255) and Table "badwords" column | type -- badword | varchar(255) I need to delete all th

[SQL] Wildcard LIKE and Sub-select

Hi everybody,I have two tables of the following structure:Table "keywords"column   | type-id   | integerkeyword | varchar(255)andTable "badwords" column   | type--badword  | varchar(255)I need to delete all the rows from the keywords table where badwo