SQL: Joining (Concatenating two strings in SQL)
(No Ratings Yet)
Loading ...December6
/*
mysql> select CONCAT(”a”,”B”);
+—————–+
| CONCAT(”a”,”B”) |
+—————–+
| aB |
+—————–+
1 row in set (0.00 sec)
*/
select CONCAT(”a”,”B”);
You can use this concat in any kind of SQL command! All depends upon your creativity. For example I had a country names database with a column for flag icons which I thoughtI would insert later on. It was empty for long time and only countries names were in it. So I got the country flag icons from a friend. Just put them in a folder and used concat for concatenating (joining) the names of the country names with a ‘.gif’ to generate the flag icons’ names! Used them in the update query and it worked. Saved me hours of data entry!
