How do I update mySQL to have first letter uppercase?
Posted: Mon Mar 21, 2016 5:24 am
I need to update all the entries in a db field, so the first letter is UPPERCASE.
I've looked online and there seems to be a few ways, but each time i try it, it errors.
This doesn't work. I get the message:
[text]#1305 - FUNCTION website.CAP_FIRST does not exist [/text]
Is it because this is "old"??
I've looked online and there seems to be a few ways, but each time i try it, it errors.
Code: Select all
mysql_query("UPDATE pages SET title = UC_Words(title) WHERE id = '$row->id'");[text]#1305 - FUNCTION website.CAP_FIRST does not exist [/text]
Is it because this is "old"??