How to deal with problems based on mybatis like%

In this issue, the editor will bring you how to deal with the problem based on mybatis like%. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Mybatis like% question SELECT * FROM t_customconfirminfoWHERE (if (# {pduName,jdbcType=VARCHAR} IS NULL, 0 = 0, pduname = # {pduName,jdbcType=VARCHAR}) AND if (# {moduleName,jdbcType=VARCHAR} IS NULL, 0 = 0, modulename = # {moduleName,jdbcType=VARCHAR}) AND if (# {env,jdbcType=VARCHAR} IS NULL, 0 = 0, confirminfo = # {env,jdbcType=VARCHAR}) AND if (# {ossAddress,jdbcType=VARCHAR} IS NULL, 0 = 0, ossaddress = # {ossAddress,jdbcType=VARCHAR}) AND if (# {branch,jdbcType=VARCHAR} IS NULL, 0 = 0) Branch like concat (concat ('%', # {branch,jdbcType=VARCHAR}),'%') AND if (# {confirmId,jdbcType=BIGINT} IS NULL, 0 = 0, id > # {confirmId,jdbcType=BIGINT}) AND onlineinfo is null) ORDER BY CREATED DESCLIMIT 1mybatis's handling of like

1. Use "%" to splice the input parameters.

2. SQL statement string concatenation

SELECT * FROM tableName WHERE name LIKE CONCAT (CONCAT ('%', # {text}),'%')

3. Bind tag

Select id,username,email,status,createtime,updatetime from tb_user email like # {pattern} the above is how to deal with the problem based on mybatis like% shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.