Prev Next

MySQL CONCAT

The CONCAT function in MySQL is used to concatenate two or more strings into one. You can combine strings from different columns or even include literal strings.

Examples with Tamil Kings

1. Concatenating Two Columns

SELECT CONCAT(king_name, ' ruled during ', reign_period) AS king_reign FROM tamil_kings_auto_increment;

Code Explanation: This query concatenates king_name, a literal string ' ruled during ', and reign_period into a single string and renames the result as 'king_reign'.

2. Concatenating with a Space

SELECT CONCAT(king_name, ' ', kingdom) AS full_description FROM tamil_kings_auto_increment;

Code Explanation: This query concatenates king_name and kingdom with a space in between.

Best Practices

  • Use CONCAT to join strings for display purposes or when constructing meaningful descriptions.
  • Ensure that you handle NULL values appropriately, as CONCAT may return NULL if any argument is NULL.

Key Takeaways

  • The CONCAT function combines multiple strings into one.
  • Use it to create descriptive or formatted output strings.
Prev Next