According to the search box input content how to write to the backend database fuzzy query

In the title and sub_title fuzzy query by the two field

Great god help me help to write it

CodePudding user response:

My top

CodePudding user response:

Key to field isn't directly using the like content fuzzy query execution? What's the difficulties of other technical requirements for

CodePudding user response:

Select * from tableName Where the title like '% % queries or sub_title like' % query content % '

CodePudding user response:

reference 3 floor scene at the beginning of JingChu, reply:

select * from tableName Where the title like '% % queries or sub_title like' % % queries'

a SQL statement, but a search box to accept input the background over error Field error in object 'testpojo on Field' id ': rejected value [success]. Codes [typeMismatch. Testpojo. Id, typeMismatch. Id, typeMismatch. Int, typeMismatch]; The arguments [org. Springframework. Context. Support. DefaultMessageSourceResolvable: codes (testpojo. Id, id), the arguments []; the default message [id]]. The default message [Failed to convert the property value of type 'Java. Lang. String' to the required type 'int' for the property 'id'; nested exception is Java. Lang, a NumberFormatException: for input String: "success"]]