How to write a Select sentence.

sweetywendy

How to retrieve such records from the database
Book title, the topic to which the book belongs book_ztid:
Title A 4
Title B 2,4,5
Title C 3,5,14,24,25,34
Title D 4, 24

Search for records with topic book_ztid 4 now

zeonic

select * from table where charindex(',4,',book_ztid)>0

cv4bf5d65fd

select * from tablename where charindex('4',book_ztid)>0

zeonic

select * from table where charindex(',4,',','+book_ztid+',')>0

cv4bf5d65fd

select * from tablename where charindex(',4,',','+book_ztid+',')>0

sweetywendy

Let me try it.

fanfan1980

create table T(book_name nvarchar(10), book_ztid varchar(20))
insert T select'Book Title A', '4'
union all select'Book Title B', '2,4,5'
union all select'Book Title C', '3,5,14,24,25,34'
union all select'Book Title D', '4,24'

select * from T
where charindex(',4,',','+book_ztid+',')>0

--result
book_name book_ztid
---------- --------------------
Title A 4
Title B 2,4,5
Title D 4,24

(3 row(s) affected)

wzx198846

select * from tablename where tablename where book_ztid like '4' or book_ztid like'%,4,%' or book_ztid like '4,%' or book_ztid like'%,4'

sweetywendy

If it is the ACESS database.

sweetywendy

Thewzx198846method can be used in ACESS. .

Are there any shorter sentences.