Apr 21

How to lowercase all tags in WordPress

Don’t know if any one would find this useful. I didn’t like cased tags and I just decide that lowercase is the way to go. I know you can do it with CSS but that’s not the result I want.

UPDATE `wp_terms` SET name=LOWER(name);

I had many tags are some are in capitals, some are in small letters, it looks really messy from my admin panel so I decided to clean of every thing.

You can run the above command in your SQL too if you want to do something similar. It converts tags like ‘Food and Beverage’, ‘WordPress’, ‘Jokes’ and ‘McDonalds’ to ‘food and beverage’, ‘wordpress’, ‘jokes’ and ‘mcdonalds’ respectively.

Use the command at your own risk, remember to back up your database properly before you use the function. It works for MySQL.

“How to lowercase all tags in WordPress”
one comment

  1. [...] to my previous blog post, Daryl was saying his categories are in caps [...]

    Apr 22

Leave your comment.


WordPress powered and Django inspired.
Love and elephants come after.
RSS: Posts and comments.