Update Null Value In mysql

Question

Hello I want to update field value where Field have NULL value i am using

UPDATE video
SET    like = 0
WHERE  like IS NULL;

but it's not working . can any one help me ?

maybe like is not NULL. might be empty string Try this instead : ..WHERE like IS NULL OR like = '' — 1000111
– 1000111, Commented Oct 3, 2016 at 9:56
Not working is not enough information. Are you getting any error ? I suppose you should have an error. — Abhik Chakraborty
– Abhik Chakraborty, Commented Oct 3, 2016 at 9:59
Also note that like is a reserved word. Enclose it by backtick while using — 1000111
– 1000111, Commented Oct 3, 2016 at 10:01

akrys · Accepted Answer · 2016-10-03 10:08:15Z

2

like is a keyword in SQL. e.g. where textcolumn like "%TEST%"

So you'll have to escape it, if you're using it as a column name.

Try can this:

update video set `like` = 0 where `like` is null

answered Oct 3, 2016 at 10:01

akrys

5631 gold badge3 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Suraj · Accepted Answer · 2016-10-03 09:59:13Z

0

Try this query, May be your the value of like is empty string or a spacebar.

UPDATE video
SET    like = 0
WHERE  like IS NULL
OR like =''
OR like = ' ';

answered Oct 3, 2016 at 9:59

Suraj

3,1954 gold badges32 silver badges50 bronze badges