SQL语句:
SELECT
b.ID AS BZRID,
b.ACCOUNT AS BZRDLZH,
b.NAME AS BZRNAME
FROM
(
SELECT
ID,
ACCOUNT,
NAME,
FLAG
FROM
USER_ORG UNION ALL
SELECT
ID,
ACCOUNT,
NAME,
FLAG
FROM
USER_ORG_M
) b
WHERE
1 = 1
AND b.FLAG = '1'
AND b.NAME LIKE '%德吉卓嘎%'
结果:
我确认是有数据的 当我把 AND b.NAME LIKE '%德吉卓嘎%'这个条件取消后
结果:
请问我这是什么问题呢 是因为mysql版本吗