Various ways of fuzzy query in "mybaits" MyBatis

Work, write three ways to use it, the fourth type of case matching query

1. String concatenation in SQL

SELECT * from TableName where name is like CONCAT (CONCAT ('% ', #{text}), '% ');

2. Use ${...} instead of #{...}

SELECT * from TableName WHERE name is like '%${text}% ';

3. Splicing in the program

Java

String searchtext = "%" + text + "%";

String SearchText = new StringBuilder ("%"). Append (Text). Append ("%"). ToString ();

Parametermap.put ("text", SearchText);

Sqlmap.xml

SELECT * from TableName WHERE name is like #{text};

4. Case matching Query

SELECT * from TABLENAME WHERE UPPER (SUBSYSTEM) like '% ' | | UPPER (' JZ ') | | ‘%‘

Or

SELECT * from TABLENAME WHERE LOWER (SUBSYSTEM) like '% ' | | LOWER (' JZ ') | | ‘%‘

Original Address: http://blog.csdn.net/luqin1988/article/details/7865643

Various ways of fuzzy query in "mybaits" MyBatis