Hi, i'm trying to make a query that ignore case sensitive, ignore diacritic
sensitive(accents) and use the same logic that % (percent) in SQL.
I have in my database names like: "Palácio Tiradentes", "Palácio da
Cidade", etc. I would like to make a search that ignore those things and
use the percent like logic
For example, I would make like this in SQL:
select * from collection where remove_accents(upper(name)) like '%' +
remove_accents(upper(query)) + '%'
where + concats string.
I found same semi-solutions:
1. I can use regexp to make the percent logic, like this: