What is wrong with this SQL? [closed]

Question

I've spend good hours trying to fix this one.

SELECT * 
FROM  `users`
WHERE  `IP` = `123.231.213.132`

What is wrong with this?

#1054 - Unknown column '123.231.213.132' in 'where clause' 

Answer 1

You should not use backticks with column values. you have to use either single or double quotes otherwise mysql will consider that value as a column name.

SELECT * 
FROM  `users`
WHERE  `IP` = '123.231.213.132'

Answer 2

Use single quotes rather than backtick characters for `123.231.213.132``

SELECT * 
FROM  `users`
WHERE  `IP` = '123.231.213.132'