Tjazz Tjazz - 2 months ago 9
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

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+ "'"