mysql question - GoFuckYourself.com

alex79 · 04-09-2006, 12:29 PM

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 · 04-09-2006, 12:36 PM

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

beta-tester · 04-09-2006, 01:16 PM

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

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

digifan · 04-09-2006, 01:31 PM

Jhon or John?

04-09-2006, 12:29 PM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	mysql question 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? __________________

04-09-2006, 01:16 PM	#3
beta-tester Rock 'n Roll Baby! Join Date: Sep 2004 Location: USA, temporarly Posts: 22,562	bad idea.... I just think you missed one ' try this query: SELECT FROM books WHERE authors like '%,Jhon_Wilson,%'; __________________ Sig for sale. Affordable prices. Contact me and get a great deal ;) My contact: ICQ: 944-320-46 e-mail: manca {AT} HotFreeSex4All.com

04-09-2006, 01:31 PM	#4
digifan The Profiler Industry Role: Join Date: Oct 2002 Location: ICQ 76281726 and I'm female Posts: 14,618	Jhon or John? __________________ [email protected] Webair Rocks

04-09-2006, 12:36 PM	#2
apson Registered User Join Date: Apr 2006 Posts: 4	Oh wow...you should never have a table with data like that. Anyway... add LIMIT 1 onto the end of your sql.