MySQL: Use CONCAT to include text in SELECT results

Home -> Database -> MySQL

From the computer of: qmchenry (338 recipes)
Created: Jan 31, 2007     Updated: Feb 05, 2007

Add to:

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:

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.