无法使用phpmyadmin执行查询
问题描述:
SELECT email, record_id
FROM (SELECT email, record_id
FROM record_data
WHERE email NOT REGEXP (SELECT GROUP_CONCAT(pattern SEPARATOR '|')
FROM blockedcompanies) tmp
)
WHERE email NOT REGEXP(SELECT GROUP_CONCAT(email SEPARATOR '|')
FROM unsubscribed);
此查询有什么问题?我收到以下语法错误:无法使用phpmyadmin执行查询
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tmp) WHERE email NOT REGEXP(SELECT GROUP_CONCAT(email SEPARATOR '|') FROM un' at line 4
答
我相信:
SELECT email,record_id FROM
(
SELECT email,record_id FROM record_data WHERE email NOT REGEXP
(
SELECT GROUP_CONCAT(pattern SEPARATOR '|') FROM blockedcompanies
) tmp <--ROMOVE THIS HERE
) <-- and put it here.
WHERE email NOT REGEXP(
SELECT GROUP_CONCAT(email SEPARATOR '|') FROM unsubscribed
);
感谢名单gbtimmon ... – 2013-05-14 13:37:12