In SQLite How to exclude rows containing specific rows?

Question

Here is my SQLite table (in comma-delimited format):

ROWID,COLUMN 1,"This here is a string |||" 2,"Here is another string" 3,"And yet another string" 

I want to exclude all lines under "COLUMN" that contain "|||". Is this possible in SQLite?

Answer 1

 select * from table where column not like '%|||%' 

it should work

Answer 2

 select * from your_table where your_column not like '%'|||%' 

SQLFiddle demo