MySQL Forums
Forum List  »  PostgreSQL

Re: Confusion following crossover from PGSQL
Posted by: Alex Moen
Date: December 16, 2008 02:48PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
8988
December 16, 2008 09:44AM
Re: Confusion following crossover from PGSQL
5143
December 16, 2008 02:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.