MySQL String Function equivalent to PHP ucwords() function

Question

Is there a MySQL String function equivalent to PHP ucwords() function.

The end goal is to use MySQL to uppercase the first letter of each word in a string.

Example. -- The name field in the table holds "JOHN DOE"

SELECT LOWER(name) FROM table

This will give me the result 'john doe'

I want the result 'John Doe'

Answer 1

www.artfulsoftware.com