如何在有分隔符“;”的字符串中搜索整个单词?

要搜索 CSV 列表中的字段，一种方法是：

where ';' + mycol + ';' like '%;mri;%'

在 DB Fiddle 上演示：

with 
    csv as (select 'Blood work;MRI;ICC' v),
    match as (select 'mri' m union all select 'Blood work' union all select 'Blood')
select csv.v, match.m,
    case when ';' + csv.v + ';' like '%;' + match.m + ';%' 
        then 'match' 
        else 'no match' 
    end matched
from csv
cross join match 
v                  | m          | matched 
:----------------- | :--------- | :-------
Blood work;MRI;ICC | mri        | match   
Blood work;MRI;ICC | Blood work | match   
Blood work;MRI;ICC | Blood      | no match