O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

Expression

CompanyName || ' is based in ' || City

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

MySQL example:

SELECT CONCAT(BowlerFirstName, " ", BowlerLastName, " lives in " , BowlerCity) FROM Bowlers;