How to Concantenate Strings
A word of warning about concatenating with sql, if the data used is one that is created by a user where query strings are created dynamically, there could be a possibility of an sql injection. This method is best used for outputting information you have in a database. For example, let’s say you have a products table and you want to concatenate the product name and price.
SELECT CONCAT (productName, ” , ” , price) FROM products;
The output would be: XBOX, $399
You can see the power in this function. We could just as well add some text modifiers:
SELECT CONCAT (productName, ” , “”Buy it Now,” , price) FROM products;
The output would be: XBOX, Buy it Now, $399
The Concat operator is used mainly by mysql. Other database engines such as Oracle use the “||” operator.
[…] the price we concatenated with a string? What if we wanted to see the average price of all our the products in our products table? SELECT […]
[…] running more complex queries, such as concatenating strings, often times you may need to trim whitespace from the […]