Re: Confusion following crossover from PGSQL

[Alex Moen]

OK, that works pretty well...

However, another thing is that in the Postgresql version, I can use multiple columns in the WHERE clause:

select * from {table} where {colunm1 || column2 || column3} ~* {data};

When I try to do this using mySql, it errors out.

So how do I use the WHERE ... LIKE to find data in multiple columns? From what I understand so far from the docs, in order to do this in MySQL I have to index the columns that I want to search and use the MATCH ... AGAINST form.

Thanks again,

Alex