Q&A
| Q1: | Are there any other string functions that might be useful to me? |
| A1: | Yes. PHP has more than 60 string functions! You can read about them all in the PHP Manual online at http://www.php.net/manual/ref.strings.php. |
| Q2: | Can I use multiple functions in one statement, such as making a concatenated string all uppercase? |
| A2: | Sure?just be mindful of your opening and closing parentheses. This example shows how to uppercase the concatenated first and last names from the master name table:
mysql> SELECT UCASE(CONCAT_WS(' ', firstname, lastname)) FROM table_name;
+--------------------------------------------+
| UCASE(CONCAT_WS(' ', firstname, lastname)) |
+--------------------------------------------+
| JOHN SMITH |
| JANE SMITH |
| JIMBO JONES |
| ANDY SMITH |
| CHRIS JONES |
| ANNA BELL |
| JIMMY CARR |
| ALBERT SMITH |
| JOHN DOE |
+--------------------------------------------+
9 rows in set (0.00 sec)
If you want to uppercase just the last name, use
mysql> SELECT CONCAT_WS(' ', firstname, UCASE(lastname)) FROM master_name;
+--------------------------------------------+
| CONCAT_WS(' ', firstname, UCASE(lastname)) |
+--------------------------------------------+
| John SMITH |
| Jane SMITH |
| Jimbo JONES |
| Andy SMITH |
| Chris JONES |
| Anna BELL |
| Jimmy CARR |
| Albert SMITH |
| John DOE |
+--------------------------------------------+
9 rows in set (0.00 sec)
|
