Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "what is the method of mybatis using concat fuzzy query". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Use the concat fuzzy query select distinct b.* from base_apparatus b left join base_apparatus_column con b.ID = c.apparatus_id CONCAT (IFNULL (b.namethschems'), IFNULL (code,''), IFNULL (serial,''), IFNULL (location,'') IFNULL (remark,''), IFNULL (b.createuserjigme'), IFNULL (b.updateworthy userjournal'), IFNULL (c.fieldworthy valuevaluation), IFNULL (batch_no,'') like CONCAT ('%', # {keyWord},'%')

The concat () function is used to concatenate multiple strings into a single string

This example

KeyWord is empty query all, keyWord is not empty, retrieve all fields in all contact match content.

Be careful

All fields need to be judged by IFNULL, otherwise a blank field may result in the loss of a record in the query result

Error using concat ('%', # {str},'%') for fuzzy query

After a messy and clueless search, I found that it was not the reason for mybatis. It turned out that SQL server did not support the concat function. Just connect with the plus sign directly.

This is the end of the content of "what is the method of mybatis using concat fuzzy query". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.