MySQL: Use CONCAT to include text in SELECT results
Contributed by qmchenry 
Tagged: MySQL The CONCAT function in MySQL allows SELECT statements to act like printf commands by mingling text and query results together.
For example, to generate a quick list of links in HTML from a table ‘links’ with the columns ‘url’ (http://www.tech-recipes.com) and ‘title’ (Tech-Recipes) so that the output looks like:
use a select statement like:
SELECT CONCAT('<a href="', url, '">', title, '</a><br />') FROM links;
The CONCAT function simply joins the comma-separated list of strings and expressions (in this case column results from the query: url and title). As with any SELECT statement, the result set can be varied with the use of an optional WHERE clause and other valid SQL syntax.
You may also like -
Save MySQL query results into a text or CSV file
Use regular expressions in MySQL SELECT statements
SQL Server 2005: Return a Comma Delimited Result Set from Queries
Select a MySQL database to use
Mimic The MySQL LIMIT Feature in Microsoft SQL Server
SQL Server 2005: Configure Max Number of Characters Displayed in Each Column
Drop or delete a table in MySQL
Display a list of databases on a MySQL server
mark said on March 31, 2009
sux. the formatting is screwed by the CMS…also the descriptive text is ultra-terse…
axinos said on April 25, 2009
and it still has not been fixed! ;-(
please fix the recipe or remove it – not to waste the time of your fellow/following chefs ;-)
Quinn McHenry said on April 25, 2009
Oops! Sorry about that! It’s been fixed now. We had to fix hundreds of posts when we migrated to a new CMS, but this one escaped detection! Thanks for pointing it out.
Thieuhuann said on May 13, 2011
It wrong