Product table contains tags columns: tag columns contain tags separated by semicolon like How to find all rows where tag1 and tag2 columns contain at least one same tag ? For example row should be in result since both columns contain AC Row Should not be in result since all tags are different. Using PostgreSQL 13.2 Answer You can use