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?
closed as too localized by anu, markratledge, Wyck, Brian Fegter, kaiser Sep 1 '12 at 1:30
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
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"