Join with like/ilike
I've two tables.
The first table contains a varchar column with any text.
The second table contains also a varchar column with some fixed entries.
The entries of the second table can occur in the first table in the specified column, but they can also be only a part of the text.
I want to select only the matching entries from table A:
In the join component I have the following expression:
"table_a". "text" ilike '%'||"table_b". "text"||'%'
Unfortunately this does not work and the resultset is empty.
Is the syntax different in Redshift? (I couldn't find anything).
Or doesn't it work the way I want it to?