Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I use postgresql database and the need is to return all the rows that contain a given string in any column of that table. For example, I have a table like this.
I need a query to return all rows that has Italy in any of their columns i.e the query shoud return 1st and 3rd rows.
You can use an IN condition for that:
select *
from the_table
where 'Italy' IN (name, native, place);