SQL: Select wordpress posts with given text string and add a custom field to them?

Question

I want to select all wordpress posts that have a certain text string.

Then to add a custom field to all those posts.

Here is what I figured out so far but it doesn't work

INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT ID AS post_id, 
       'customer_reviews' AS meta_key, 
       'On_or_delete' AS meta_value
FROM   wp_posts 
WHERE  ID IS IN
       (SELECT post_id 
        FROM wp_posts
        WHERE post_content LIKE '%Customer Reviews%')
       AND post_type = 'post';

Anyone know how to do this please?

If you use PHPMyAdmin you can easily create the MySQL query you need to select all posts where post_content like 'something' and do a PHP loop to add the custom fields. If this is the only issue, the Question is off-topic (pure PHP and/or pure MySQL). — brasofilo
– brasofilo, Commented Jul 1, 2013 at 15:34
What a vague answer. Your vagueness is strange in the case of answering a technical question that specifically states what the intended solution is to be. I've said I know how to do one part, and I've actually got further: — Mark
– Mark, Commented Jul 1, 2013 at 16:45
It's not an Answer. The Comments area of a Question&Answer site is used to provide feedback and request clarifications about the Q, so it can be improved. Check the pages tour and help center. — brasofilo
– brasofilo, Commented Jul 1, 2013 at 16:51
Apologies. I have updated the question with more information and a clearer picture of what I've tried to do. I'm new to this so you have to forgive my misunderstanding of both SQL and WP. Thanks. — Mark
– Mark, Commented Jul 1, 2013 at 17:07
The WP way of doing this is with a custom plugin with one DB query (get post ID's where content LIKE) and a loop with a simple update_post_meta(). If your Question is simply how to correct this SQL query, I believe it's off-topic here, it's being close-voted as such, and candidate to migration to Stack Overflow. — brasofilo
– brasofilo, Commented Jul 1, 2013 at 17:28

GhostToast · Accepted Answer · 2013-07-01 18:29:47Z

1

Here you go (you're really close):

INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT ID AS post_id,
'customer_reviews' AS meta_key, 
'On_or_delete' AS meta_value
FROM wp_posts WHERE wp_posts.post_content LIKE '%Customer Reviews%'
   AND wp_posts.post_type = 'post';

`

Edit: You could also just change IS IN to IN. I rewrote the from part of the query since a subquery was unnecessary though.

edited Jul 1, 2013 at 18:29

GhostToast

4,6163 gold badges29 silver badges44 bronze badges

answered Jul 1, 2013 at 17:56

Chelsea Urquhart

2011 silver badge5 bronze badges

Add a comment |

Stack Exchange Network

SQL: Select wordpress posts with given text string and add a custom field to them?

1 Answer 1

Your Answer

Hot Network Questions

SQL: Select wordpress posts with given text string and add a custom field to them?

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions