求高手帮写一条满足指定条件的语句

[863]

表中有字段Admin
表中Admin数据为
Admin=|aa|bb|cc|
或者
Admin=|bb|cc|dd|ee|ff|
或者
Admin=|dd|ee|

想写一条语句查询出所有满足Admin="bb"这个条件的记录

请问这条语句应该怎么写？

sql1 = "select ID,UserName from theTable where Admin="bb""(这个条件应该怎么写啊？)

[文盲老顾]

select * from theTable where Admin like '%|bb|%'

[hyjia]

楼上的正解

[YISUKU_LEE]

select * from theTable where Admin like '%|bb|%'

[飘零雾雨]

模糊查询：
select * from theTable where Admin like '%|bb|%'

[非凡笨笨]

select * from theTable where Admin like '%|bb|%'

[xzr2004]

sql1 = "select ID,UserName from theTable where Admin like '%|bb|%' "