I have a simple query:
SELECT u_name AS user_name FROM users WHERE user_name = "john";
I get Unknown Column 'user_name' in where clause. Can I not refer to 'user_name' in other parts of the statement even after select 'u_name as user_name'?
Unknown Column 'user_name' in where clause
'user_name'
select 'u_name as user_name'
No comments:
Post a Comment