To combine strings rather than pull them apart, use the CONCAT( ) function. : CONCAT « String « SQL / MySQL

1. SQL / MySQL
2. String
3. CONCAT

To combine strings rather than pull them apart, use the CONCAT( ) function.

       
mysql>
mysql> SELECT CONCAT('Hello, ',USER( ),', welcome to MySQL!') AS greeting;
+------------------------------------------+
| greeting                                 |
+------------------------------------------+
| Hello, root@localhost, welcome to MySQL! |
+------------------------------------------+
1 row in set (0.00 sec)

mysql>
mysql> CREATE TABLE mytable
    -> (
    ->  name    VARCHAR(20)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO mytable (name)
    ->  VALUES
    ->          ('copper'),
    ->          ('gold'),
    ->          ('iron'),
    ->          ('lead'),
    ->          ('mercury'),
    ->          ('platinum'),
    ->          ('silver'),
    ->          ('tin')
    -> ;
Query OK, 8 rows affected (0.00 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT * FROM mytable;
+----------+
| name     |
+----------+
| copper   |
| gold     |
| iron     |
| lead     |
| mercury  |
| platinum |
| silver   |
| tin      |
+----------+
8 rows in set (0.00 sec)

mysql>
mysql> SELECT CONCAT(name,' ends in "d":
    '> ',IF(RIGHT(name,1)='d','YES','NO'))
    -> AS 'ends in "d"?'
    -> FROM mytable;
+--------------------------+
| ends in "d"?             |
+--------------------------+
| copper ends in "d":
NO   |
| gold ends in "d":
YES    |
| iron ends in "d":
NO     |
| lead ends in "d":
YES    |
| mercury ends in "d":
NO  |
| platinum ends in "d":
NO |
| silver ends in "d":
NO   |
| tin ends in "d":
NO      |
+--------------------------+
8 rows in set (0.00 sec)

mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
    
  

Related examples in the same category