alex79

i have a table with 1 column (authors) in this form:

row1: ..,Sam,Jhon_Wilson,Mike,Terry,...
row2:...,Dona,Jhon,Wilson,David,...
row2:...,Jenny,Barbara,Anderson,...

i want to make a select: select from books where authors like '%,Jhon_Wilson,% in order to retourn the fist row but this select is returning both rows (first row with ,Jhon_Wilson, and second row with ,Jhon,Wilson,)

what is the correct sintax to retourn only the fist row?

__________________