Sql Syntax Error [corrected] apostrophes missing

	Sql Syntax Error [corrected] - apostrophes missing
	Discussion by Eggie with 2 Replies. Last Update: February 18, 2008, 10:15 am

Eggie

QUOTE

#1054 - Unknown column 'Eggie' in 'where clause'

i get that error when i type this in MYSQL

CODE

select bike from members where username=Eggie

i have column bike,members and username...
and i have information in every of those columns...
but why does it say that there is no COLUMN because i said i want info from row where column 'username' is 'Eggie'

btw-YAY..my 101 post

EDIT:sorry...i just solved it i forgot to put apostrophes

CODE

select bike from members where username='Eggie'

Sun Feb 17, 2008 Reply New Discussion

faulty.lee

Well, this is always something a lot of ppl miss easily. Because the error "Unknown column" is quite misleading in this case. Anyway, it's good that you found out yourself.

Mon Feb 18, 2008 Reply New Discussion