select * from t_topic where id in( select id from t_topic union SELECT substring_index(test_id, ',', 1) AS id FROM t_test union SELECT substring_index(test_id, ',', -1) AS id FROM t_test )