Mysql help

[Bug]

Is there a mysql query to find all characters in database with names like tESt teTst TsTe, with capital letters in their name
ty

 

[Yodot]

Hi Bug,

A php routine to rename all players so that it capitalised the first letter of each word in their name while making the rest of the word lower case would be:


php code to do that would be (you have to use your own mysql db connection routine):

<?PHP
  $query = "SELECT * FROM `players`";
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result) {
    $oldName = $row['name'];
    $playerId = $row['id'];
    $newName = ucwords(strtolower($oldName));
    $updateQuery = "UPDATE `players` SET `name` = '$newName' WHERE `id` = '$playerId'";
    $updateResult = mysql_query($updateQuery);
  }
?>

 

[Bug]

Dint worked or i didnt found i way to use it