select CONCAT((SELECT CODE FROM GROUP_DICT D where D.CODE = '100'),'%')
实际应用
WHERE
t.CODE LIKE (SELECT
CONCAT(
(
SELECT
CODE
FROM
GROUP_DICT D
WHERE
D.CODE = '100'
),
'%'
))
实际应用
WHERE
t.CODE LIKE (SELECT
CONCAT(
(
SELECT
CODE
FROM
GROUP_DICT D
WHERE
D.CODE = '100'
),
'%'
))