Modify data before applying the filter in PostgreSQL
I’m using PostgreSQL for storing the data. It is linked with Spring boot as application server. I’m using JPA
to access the data.
Now, I have a entity named custom_user
with string property mobile_number
. The format of mobile_number
is +{{country_code}}.{{actual_number}}
(ex. +91.123, +92.456). Now, I want to filter this records using search queries such as “+91”, “123”, “+91123”, “+924”.