MySQL: Unknown column in where clause error?

In MySql, backticks indicate that an indentifier is a column name. (Other RDBMS use brackets or double quotes for this) So your query was, "give me all rows where the value in the column named 'uname' is equal to the value in the column named 'test'". But since there is no column named test in your table, you get the error you saw Replace the backticks with single quotes.

In MySql, backticks indicate that an indentifier is a column name. (Other RDBMS use brackets or double quotes for this). So your query was, "give me all rows where the value in the column named 'uname' is equal to the value in the column named 'test'".

But since there is no column named test in your table, you get the error you saw. Replace the backticks with single quotes.

Oh, so that's the real explanation ;) – meder Sep 26 '09 at 3:47.

It says exactly what's wrong. There is no 'test' column in your table. Are you sure you have the right table?

'tutorial. Users'? Are you sure the table isn't named differently?

Maybe you meant to do SELECT * from users WHERE uname = 'test'; You have to reference only the table name, not the database.. assuming the database is named tutorial.

Works now, thanks – user169551 Sep 26 '09 at 3:20 Yeah I think he is adding the name of the database in the query.. or maybe he wants to select tutorial. Users from users where uname='test'; – halocursed Sep 26 '09 at 3:24 np. Don't forget to select an answer :) and welcome to Stackoverflow.

– meder Sep 26 '09 at 3:30.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.