SELECT GROUP_CONCAT label_id AS label_id GROUP_CONCAT label_name AS label_name FROM uc_user_label WHERE FIND_IN_SET uc_user_labellabel_id SELECT oss_push_trumppush_label_id FROM oss_push_trump 0
将子查询的结果改为只返回一行数据。可以使用LIMIT关键字来限制子查询返回的结果集数量。例如:
SELECT GROUP_CONCAT( label_id ) AS label_id, GROUP_CONCAT( label_name ) AS label_name FROM uc_user_label WHERE FIND_IN_SET( uc_user_label.label_id, ( SELECT oss_push_trump.push_label_id FROM oss_push_trump LIMIT 1 )) > 0
原文地址: https://www.cveoy.top/t/topic/hAUB 著作权归作者所有。请勿转载和采集!