Re: [sqlite] Linking all the column fields together (or something like this)

2009/8/20 ZB : > I need to search a table, which has - say - about 20 columns. Each column > should be checked against given string ("phrase"), in usual manner: > >  SELECT something FROM table WHERE col1 LIKE '%phrase%' OR col2 LIKE >  '%phrase%' OR col3 LIKE '%phrase%' ... OR col20 LIKE '%phrase%

[sqlite] Linking all the column fields together (or something like this)

I need to search a table, which has - say - about 20 columns. Each column should be checked against given string ("phrase"), in usual manner: SELECT something FROM table WHERE col1 LIKE '%phrase%' OR col2 LIKE '%phrase%' OR col3 LIKE '%phrase%' ... OR col20 LIKE '%phrase%' I'm afraid, it will