MySQL CONCAT returns NULL if any field contain NULL

by

convert the NULL values with empty string by wrapping it in COALESCE

SELECT CONCAT(COALESCE(`affiliate_name`,''),'-',COALESCE(`model`,''),'-',COALESCE(`ip`,''),'-',COALESCE(`os_type`,''),'-',COALESCE(`os_version`,'')) AS device_name
FROM devices

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. MySQL comparison with null value
  3. Replace null with 0 in MySQL
  4. Why in SQL NULL can’t match with NULL?
  5. how to delete data from table A besides the customer service and director data in table B?
  6. Get records with max value for each group of grouped SQL results
  7. How to populate a table with a range of dates?
  8. MYSQL OR vs IN performance
  9. SELECTING with multiple WHERE conditions on same column
  10. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  11. How to find gaps in sequential numbering in mysql?
  12. MySQL: Invalid use of group function
  13. MySQL: View with Subquery in the FROM Clause Limitation
  14. MySql export schema without data
  15. MySQL combine two columns into one column
  16. MySQL: LIMIT by a percentage of the amount of records?
  17. limiting the rows to where the sum a column equals a certain value in MySQL
  18. MySql Transpose Row into Column and Column into Row [duplicate]
  19. MySQL multiple columns in IN clause
  20. MySQL Inner Join Query Multiple Tables
  21. How to select column names dynamically in mySQL
  22. GROUP BY – do not group NULL
  23. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  24. Use Composite Primary Key as Foreign Key
  25. How to select data where a field has a min value in MySQL?
  26. How to SELECT by MAX(date)?
  27. get a recursive parent list
  28. MySql Query Replace NULL with Empty String in Select
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment