Capitalize first letter of each word, in existing table

by

There’s no MySQL function to do that, you have to write your own. In the following link there’s an implementation:

http://joezack.com/index.php/2008/10/20/mysql-capitalize-function/

In order to use it, first you need to create the function in the database. You can do this, for example, using MySQL Query Browser (right-click the database name and select Create new Function).

After creating the function, you can update the values in the table with a query like this:

UPDATE users SET name = CAP_FIRST(name);

More Related Contents:

  1. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  2. MySQL string replace
  3. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  4. How do I find the MySQL my.cnf location
  5. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  6. MySQL select one column DISTINCT, with corresponding other columns
  7. How to use mysql JOIN without ON condition?
  8. How to remove all non-alpha numeric characters from a string in MySQL?
  9. Define a variable within select and use it within the same select
  10. ERROR: Error 1005: Can’t create table (errno: 121)
  11. Mysql Convert Column to row (Pivot table )
  12. Merge two tables in one SQL query and make the date values unique
  13. MySQL FULL JOIN?
  14. How to fill in the “holes” in auto-increment fields?
  15. Using Count to find the number of occurrences
  16. Is there any reason to worry about the column order in a table?
  17. MySQL Incorrect datetime value: ‘0000-00-00 00:00:00’
  18. How to integrate ElasticSearch with MySQL?
  19. How to change MySQL table names in Linux server to be case insensitive?
  20. MySQL command line formatting with UTF8
  21. MYSQL select DISTINCT values in two columns
  22. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  23. Use promise to process MySQL return value in node.js
  24. where does MySQL store database files?
  25. How can I achieve initcap functionality in MySQL?
  26. ALTER TABLE ADD COLUMN takes a long time
  27. Creating MYSQL Procedure in Laravel 4 Migrations
  28. MySQL: Computed Column
  29. Mysql server does not support 4-byte encoded utf8 characters
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment