Relative Content

Tag Archive for javamysqlspringspring-bootspring-data-jpa

Fuzzy search logic using JpaSpecificationExecutor

I have a column c1 (varchar(400)) in table t1 in MYSql database. This column can contain data in plain text and json format like "abcd","12345.6",{"key1":"value1"},{"key1":"value1","key2","value2"} etc. I want to implement a fuzzy search logic in this column. User can search using "34", "cd",{"key1":"value1"}, "value1" etc. User can perform serch by providing a full or partial value. User can provide the entire json value or partial value.