MySQL: Use CONCAT to include text in SELECT results

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:

Tech-Recipes

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.

 

About Quinn McHenry

Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
View more articles by Quinn McHenry

The Conversation

Follow the reactions below and share your own thoughts.

  • mark

    sux. the formatting is screwed by the CMS…also the descriptive text is ultra-terse…

  • axinos

    and it still has not been fixed! ;-(

    please fix the recipe or remove it – not to waste the time of your fellow/following chefs ;-)

    • http://www.tech-recipes.com Quinn McHenry

      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

    It wrong

  • suvarna

    is it possible for concatinating of two text values;