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?
2 Answers
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.