I was having a little problem excepting all the different capitalizations in my calender, you know when you mouse over a date and the tool tip tells you the titles of entries. So I used
UPDATE wp_posts SET post_title = LCASE(post_title);
To convert all the titles to lowercase, of course this works for uppercase (UCASE), too. Just thought someone might find this useful. Remember to back up the database before you do anything new though 🙂
PS. For those that don’t know, this is an SQL query no WP code was hacked. See the SQL manual.
- You must be logged in to reply to this topic.