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?
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.
WP Title Case plugin would a much simpler solution. It automatically transforms titles across your website to show proper case.
"the quick brown fox" will appear as "The Quick Brown Fox"
"i like wordpress so much" will appear as "I Like WordPress so Much"