I have street names in a column (column1) as well as in another one (column2). I would like to write a selection expression to find out if there are similar street names (or parts of the names) between column1 and column2.
I tried the following expression, but nothing happened. Basically, this is what I would like to achieve but it seems like this is not the right solution:
"column1" like '%"column2"%'