mysql - 如何拆分逗号分隔值

Question

我的表 myTable 具有这样的字段

tranType              Source
-------------------------------------
RC,RD,RF,RR           PB,CM

我想创建在查询中使用 tranType 和 Source 的值作为条件的存储过程

select * 
from myTable
where Source = @valSource  -- PB (check for each value from Source)
  AND tranType = @valTrantype  -- RC(check for each value from tranType)

它将检查该字段中的所有值

Answer 1

请检查以下内容:

select * from myTable 

where find_in_set(@valSource,Source) 

AND find_in_set(@valtranType,tranType)