关于Mysql中InnoDB引擎不支持contains方法的解决方案

关于Mysql中InnoDB引擎不支持contains方法的解决方案

SELECT
  A.F1 id,
  A.F13 voucherReimbStatus,
  B.F2 voucherCode,
  B.F3 voucherName,
  B.F9 voucherValue,
  B.F10 validTime,
  A.F11 beginTime,
  A.F12 endTime,
  C.USERNAME userAccount,
  C.USERTYPE userType,
  C.USERREALNAME userName,
  C.MOBILE mobile,
  (SELECT GROUP_CONCAT(F3) FROM TB4276 WHERE B.F1 = F2) voucherUseScope
FROM
  PT4277 AS A
  LEFT JOIN TB4275 AS B ON A.F4 = B.F1 
  LEFT JOIN TB_User AS C ON A.F2 = C.USERID
WHERE 1=1
-- HAVING CONTAINS(voucherUseScope,'101')  // 不支持
HAVING voucherUseScope LIKE '%101%'