Remove all WordPress Featured Images

  2018-05-11      109 words, 1 minutes

• mysql
• sql
• wordpress

I used to use “Featured Images” in my posts to illustrate the main tag. Now that I changed my theme (namely Twenty Fourteen), those icon-sized images don’t show up well. I decided to simply drop them all so that nothing is displayed by the theme. This is done easily using MySQL:

> SELECT COUNT(*) FROM wp_postmeta WHERE meta_key="_thumbnail_id";
+----------+
| COUNT(*) |
+----------+
|       38 |
+----------+
1 row in set (0.00 sec)

> DELETE FROM wp_postmeta WHERE meta_key="_thumbnail_id";
Query OK, 38 rows affected (0.01 sec)

>  SELECT COUNT(*) FROM rajah_postmeta WHERE meta_key="_thumbnail_id";
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

Done.