可以这么写:
... where field1 regexp (select replace(config_value, ',', '|') config_value from table1 where ... ) ...