[SOLVED] Can not SELECT text?!

[razta]

Hello,

For some reason I cannot get MySQL to SELECT text...

 

This works:

SELECT *
FROM `users`
WHERE `user` = 1337

 

This doesnt:

SELECT *
FROM `users`
WHERE `user` = admin

 

The error I get when executing the second command is:

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

 

However admin is there just like 1337 is. The column user is set to varchar(15).

 

Any ideas?

 

 

[Maq]

You should have your value in single quotes if the `user` field is a VARCHAR.

 

SELECT *
FROM `users`
WHERE `user` = 'admin'

[razta]

Got it!  :-\

 

SELECT *
FROM `users`
WHERE user = 'admin';

 

Thanks Maq

[Maq]

Got it!  :-\

 

SELECT *
FROM `users`
WHERE user = 'admin';

 

Thanks Maq

 

Good, I marked as solved for you.  Next time there's a topic solved tab, bottom left.

[razta]

Thanks again!