How to write a query with a semicolon in a field

freezeboi

Excuse me, the id field of the table person holds multiple data separated by semicolons in the content, which is "123; 234; 345".
select * from person where id .....
The variable corresponding to id is 123, which is a part of the content of id.
How to write the query?

啊啦是奶牛

select * from person where charindex (id, '123')> 0

我是杀人狂

select * from person where id like '% 123%'

fanfan1980

--try
select * from person where charindex ('123', id)> 0
or
select * from person where id like '% 123%'

啊啦是奶牛

select * from person where charindex ('123', id)> 0

smallwarrior

Upstairs are the answers, haha