Easy MySQL question: query with a null value

Question

What am I doing wrong with this query? (Friday afternoon brain freeze...)

In WordPress, I used a MySQL query to make an empty custom field called "description" in all posts of a test database, and now I want to add the value "test" to that field. (This is all in the process of teaching myself how to write more complex queries.)

But I can't get this query to deal with the fact that the field has no value. 'NULL' doesn't work (and it appears that or IS NULL is what I should be using, according to other stackoverflow answers), and '%' doesn't.

UPDATE `wp_postmeta` SET `meta_value` = replace(meta_value, 'IS NULL', 'test') WHERE `meta_key` LIKE 'description'

Oscar Chan · Accepted Answer · 2009-08-28 22:23:27Z

3

I think you want

UPDATE `wp_postmeta` SET `meta_value` = 'test'
 WHERE `meta_key` LIKE 'description'
   and `meta_value` is null

answered Aug 28, 2009 at 22:23

Oscar Chan

1,62211 silver badges13 bronze badges

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

2 Comments

markratledge Over a year ago

Nice - that works great. Thanks! You must have beaten Noah by only a few seconds....

Oscar Chan Over a year ago

yes, I did. I found out his post was 20 seconds after mine when I was double checking my answer. I guess I got lucky :)

Noah · Accepted Answer · 2009-08-29 16:03:58Z

1

You could try:

UPDATE `wp_postmeta` 
SET `meta_value` = 'test'
WHERE `meta_key` LIKE 'description'
AND `meta_value` IS NULL

edited Aug 29, 2009 at 16:03

answered Aug 28, 2009 at 22:24

Noah

14k4 gold badges39 silver badges45 bronze badges

Collectives™ on Stack Overflow

Easy MySQL question: query with a null value

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related