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

Editor to share with you how to write the fuzzy query like statement in Mybatis, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

How to write fuzzy query like statement

(1)'% ${question}% 'may cause SQL injection and is not recommended

(2) "%" {question} "%" Note: because # {… } when parsed into a sql statement, single quotation marks are automatically added to the outside of the variable, so here% you need to use double quotation marks, not single quotation marks, otherwise you will not be able to find any results.

(3) CONCAT ('%', # {question},'%') uses the CONCAT () function, which is recommended

(4) use bind tags

Select id,sex,age,username,password from person where username LIKE # {pattern} above are all the contents of this article entitled "how to write fuzzy query like statements in Mybatis". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.