SQL unknown column in where clause

Question

I get this error:

Error: UPDATE stats SET stat2='2' WHERE name=views
Unknown column 'views' in 'where clause'

In the table 'name' is the column, and 'views' is a value in that column.

As far as I can tell from the documentation the statement "WHERE name=views" should be read as "WHERE {column}={cell value}", whereas the error is inferring that the column name is the second value.

score 2 · Accepted Answer · answered Jul 04 '20 at 05:13

2

You need to put the values within '' since it's a string value

UPDATE stats SET stat2='2' WHERE name='views'

answered Jul 04 '20 at 05:13

Fahmi

37,315
5
22
31

@IsaacWestenra,, if it helped you please mark it as accepted – Fahmi Jul 04 '20 at 05:23

SQL unknown column in where clause

1 Answers1