Em quinta-feira, 14 de abril de 2016 19:52:09 UTC-3, Christian Cardozo
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: