Untitled

select statement over multiple columns in SQLite

sqlite> select issue,url,steps from help where kw1='adobe';

       

blank popup|blankpopup.html|S

missing pdfs|missingpdfs.html|S

printall not populating|printall.html|A

       

sqlite> select issue,url,steps from help where kw1='ie' or kw2='ie' or kw3='ie' or kw4='ie' or kw5='ie' or kw6='ie' or kw7='ie' or kw8='ie' or kw9='ie' or kw10='ie' or kw11='ie' or kw12='ie';