By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
temp_columns |
---|
dog |
pets |
concat('%', UPPER(trim(ads.temp_columns)), '%') |
---|
%DOG% |
%PETS% |
id | title |
---|---|
2 | This PETS is very nice |
4 | This dOG is very nice |
id | title | temp_columns |
---|---|---|
2 | This PETS is very nice | pets |
4 | This dOG is very nice | dog |