How do I modify an attribute across all rows in a table?

Posted by prgmatic on Stack Overflow See other posts from Stack Overflow or by prgmatic
Published on 2010-04-07T00:31:59Z Indexed on 2010/04/07 0:33 UTC
Read the original article Hit count: 283

Filed under:
|
|
|
|

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:

  1. Take the values of a column in a table (text)
  2. Change them into capitalized words (from "this is a title" to "This Is A Title")
  3. Replace the old values (uncapitalized) with the new values (capitalized).

Thanks for the help and support.

© Stack Overflow or respective owner

Related posts about database

Related posts about mysql