Make all characteristic values start with uppercase?

[webbusiness23]

Hello,

 

I need all the characteristic values inside the table ps_feature_value_lang start with uppercase ( i need only the first letter of the first word to be uppercase)

 

Example 1: 

before: wood

after: Wood

 

Example 2: 

before: plastic material

after: Plastic material

 

Anyone can help me with a sql query?

Thank you!

[Rolige]

Hello:

You can find solution here: https://www.w3resource.com/mysql/string-functions/mysql-ucase-function.php

Regards

[webbusiness23]

17 hours ago, Rolige said:

Hello:

You can find solution here: https://www.w3resource.com/mysql/string-functions/mysql-ucase-function.php

Regards

 

Thank you for the suggestion, but i need only the first letter of the first word to be uppercase.

 

I've tried this so far (as suggested by a friend), but with no success (it says zero rows affected after i simulate query).

 

UPDATE `ps_feature_value_lang` SET `value`= CONCAT(UCASE(SUBSTRING(`value`, 1, 1)), LOWER(SUBSTRING(`value`, 2)))

Am i missing something?