Searching multiple columns using WHERE

[Relaxasaurus]

Is this possible:

Select * FROM users WHERE * LIKE %%searchterm%%

Basically, I want to search multiple columns rather than a single one. Lisiting the column names individually and separating them by commas, 'AND', or 'OR' returns a syntax error.

Thanks for any help.

[sacx13]

need to work with multiple columns separated by 'OR' or 'AND'

just try:

select * from table where col1 like '%searchterm%' or col2 like '%searchterm%' or col3 like '%searchterm%';

Best Regards
A.

[chazzy]

some dbms also provide simpler solutions for this instead of an or. in mysql you can use its full text search. you can try using a concat in oracle as well.

[Hack]

As Chazzy points out, different databases offer different alternatives.

What database you using?

[chitwan]

in case there are fixed number of columns you are looking into, a revert of SQL IN statement will do the trick, an example can be seen here http://alltips.in/mysql-search-multiple-columns/

[ssystems]

some dbms also provide simpler solutions for this instead of an or. in mysql you can use its full text search. you can try using a concat in oracle as well.

And engines as well. MSSQL also have full text search.