mysql question

[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?

[apson]

Oh wow...you should never have a table with data like that. Anyway... add LIMIT 1 onto the end of your sql.

[beta-tester]

bad idea....
I just think you missed one '
try this query:

SELECT FROM books WHERE authors like '%,Jhon_Wilson,%';

[digifan]

Jhon or John?