mysql find_in_set匹配2列

Question

我有一个像这样工作的 find_in_set 查询

$groupid = 245;
$formsidlist = '52,57,103,104,105,107,109,110';
$query = "SELECT * FROM #__immi_visaformfields WHERE 
FIND_IN_SET('$groupid','field_duplicate')  AND published='1' AND 
 FIND_IN_SET(formid,'$formsidlist') ORDER BY id";

现在我已将 formsidlist 更改为

$formsidlist = '52-1,57-2,103-1,104-1,105-2,107-1,109-1,110-1';

从 52-1 开始，52 应与 formid 列进行比较，1 应与 formversionid 列进行比较。

我如何实现这个目标？

Answer 1

将 formid 与“-”和 formversionid 连接起来:

FIND_IN_SET(concat(formid, '-', formversionid), '$formsidlist') ORDER BY id";