连接字符串啊 !比如酱紫
mysql> select concat(‘11’,’22’,’33’);
+————————+
| concat(‘11’,’22’,’33’) |
+————————+
输出:| 112233 |
Like表达式
oracle数据库:
Java代码
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
或
Java代码
SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'
SQLServer数据库:
Java代码
SELECT
*
FROM
user
WHERE
name like '%'+#{name}+'%'
mysql数据库:
Java代码
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
DB2数据库:
Java代码
SELECT
*
FROM
user
WHERE
name like CONCAT('%',#{name},'%')
或
Java代码
SELECT
*
FROM
user
WHERE
name like '%'||#{name}||'%'