What exactly i want is really a query or some tip regarding how to turn all game titles on the wordpress powered website into capitalized situation.

Things i have finally is one thing such as this:

AAAAA BBBBB CCCCC

I would like it to end up like this:

Aaaaa Bbbbb Ccccc

Used to do try searching and looking out here, but have unsuccessful at this task so any assistance is much appreciated!

UPDATE:

I have to update game titles within the database. Simply to be obvious. :)

There's no function in MySQL with this, but you may create one such as this:

DROP FUNCTION IF EXISTS proper;
SET GLOBAL  log_bin_trust_function_creators=TRUE;
DELIMITER |
CREATE FUNCTION proper( str VARCHAR(128) )
RETURNS VARCHAR(128)
BEGIN
  DECLARE c CHAR(1);
  DECLARE s VARCHAR(128);
  DECLARE i INT DEFAULT 1;
  DECLARE BOOL INT DEFAULT 1;
  DECLARE punct CHAR(17) DEFAULT ' ()[]{},.-_!@;:?/';
  SET s = LCASE( str );
  WHILE i < LENGTH( str ) DO 
    BEGIN
      SET c = SUBSTRING( s, i, 1 );
      IF LOCATE( c, punct ) > 0 THEN
        SET BOOL = 1;
      ELSEIF BOOL=1 THEN 
        BEGIN
          IF c >= 'a' AND c <= 'z' THEN 
            BEGIN
              SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1));
              SET BOOL = 0;
            END;
          ELSEIF c >= '0' AND c <= '9' THEN
            SET BOOL = 0;
          END IF;
        END;
      END IF;
      SET i = i+1;
    END;
  END WHILE;
  RETURN s;
END;
|
DELIMITER ;

From here.

The you are able to update easily by running:

Update wp_posts
Set post_title = proper(post_title)

You can let it rest as-is incorporated in the database and pressure the title to show with first-letters in capitals via css:

h2 {
  text-transform:capitalize;
}

would you try wrapping wordpresses the_title(); function with ucwords and strtolower

<?php echo ucwords(strtolower(the_title(null, null, false))); ?>

From things i can gather this takes the title value uses strtolower to show it into lowercase, then ucwords to capitalize each word.

I've not attempted this myself so i'm not sure it's works but this is the way i'd check it out.

Hope this can help

EDIT: right i have had a glance at among my old files, inside your functions.php you can define a function to hook in to the save_publish action. While using publish variable you need to have the ability to adjust that data, but like others have stated you need to be careful incase it does not make the preferred effect.

add_action('save_post', 'save_postdata');
function save_postdata($post_id) {
    //edit code here
    update_post_meta($post_id, 'title', $title);
}

I am while using update_post_meta() function, i am unsure of if the is able to edit the title, i do not have to capability to operate a test regrettably.

Exactly what do everyone think?

Only use ucwords( $title ) by themselves - but look at your use cases cautiously - acronyms don't finish up exhibiting as the customers might expect.

"beginners help guide to TLAs" will end up "Beginners Help Guide To Tlas"

For that record, the MySQL function cited above fails once the last character stands alone, e.g.,

Public John q

There's a simple workaround, if you do not need padding:

trim(proper(concat(myfield, '    ')))