Changing title to lowercase

Lets say i have 100 posts. And i would like to lowercase the title. but only 70 of it. I cant use text-transform or mb_strtolower. Is there anyway to download posts and lowercase the title with microsoft word and reupload it?

Related posts

Leave a Reply

2 comments

  1. Assuming this question is related to WordPress, here is answer :- You can update the titles directly into your mySQL database using simple update function.

    one of my user publishs all his posts uppercase (title) i want to edit them and make it normal. –

    Using some conditional statements as I mentioned in this code, you can restrict the update for particular user(replace ‘user_id’).

    UPDATE wp_posts SET post_title=LOWER(post_title) WHERE post_author = "user_id"
    

    This will transform all post titles into lowercase by that user.

  2. WP Title Case plugin would a much simpler solution. It automatically transforms titles across your website to show proper case.

    For example:

    “the quick brown fox” will appear as “The Quick Brown Fox”

    “i like wordpress so much” will appear as “I Like WordPress so Much”