Gossamer Forum
Home : General : Databases and SQL :

NOT LIKE

Quote Reply
NOT LIKE
Hi,

I would like to display alle pages where the body doesn't start with "SCRIPT=". I know how to get the pages that does start with an SCRIPT, but not how to get the pages that doesn't.... (Adding <> looks naturally, but is a wrong statement.)

Code:
SELECT * FROM websitecontent WHERE body LIKE 'SCRIPT=%'
Quote Reply
Re: [cK] NOT LIKE In reply to
Didn't you just answer your own question in the title of your thread? Crazy
Quote Reply
Re: [Paul] NOT LIKE In reply to
Stupid of me Blush