How do I modify an attribute across all rows in a table?
- by prgmatic
Hi folks,
My apologies for asking such a novice question but, I need help building a script using either PHP or directly in MySQL that can do the following:
Take the values of a column in a table (text)
Change them into capitalized words (from "this is a title" to "This Is A Title")
Replace the old values (uncapitalized) with the new values (capitalized).
Thanks for the help and support.