Tjazz Tjazz - 1 year ago 92
SQL Question

Unknown column '<name>' in 'where clause'

I have a connection with a database table, called user, where I want to get the text from "todo". But I keep getting an "unknown" error.

This is the Code I have so far:

"SELECT `todo` FROM `user` WHERE `username` LIKE `" + _name+ "`"

Note: I'm a starter with sql, so please be specific.

Answer Source

Table name and column name only enclosed by backticks not for string values .so remove backticks in where clause near like and add single quotes for string values.

"SELECT `todo` FROM `user` WHERE `username` LIKE '" + _name+ "'"
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download