当前位置：网站首页>The writing method of like% variable% in Oracle SQL

The writing method of like% variable% in Oracle SQL

2022-07-18 13:46:00 【Smile and refuel】

orcale Under the premise of database ,mybatics frame , Fuzzy query splicing is required % The scenario is as follows

select * from user where username like '%username%'

That requires fuzzy query of the passed variables , There are two ways to write
1. call mapper Interface , Use variables % Splicing

User user= usermapper.queryUserByUserName("%+userName+%");

2. stay sql In dealing with , Use concat Function

//orcale Medium concat Function can only splice two variables 
select * from user where username like CONCAT(CONCAT('%',#{
    channelType}),'%')

版权声明
本文为[Smile and refuel]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/199/202207160419323322.html