String concatenation in MySQL

by

MySQL is different from most DBMSs’ use of + or || for concatenation. It uses the CONCAT function:

SELECT CONCAT(first_name, ' ', last_name) AS Name FROM test.student

There’s also the CONCAT_WS (Concatenate With Separator) function, which is a special form of CONCAT():

SELECT CONCAT_WS(' ', first_name, last_name) from test.student

That said, if you want to treat || as a string concatenation operator (same as CONCAT()) rather than as a synonym for OR in MySQL, you can set the PIPES_AS_CONCAT SQL mode.

More Related Contents:

  1. Calculate date range between two rows
  2. Can I concatenate multiple MySQL rows into one field?
  3. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. How to use GROUP_CONCAT in a CONCAT in MySQL
  6. MySQL: How to allow remote connection to mysql
  7. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  8. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  9. MySQL error code: 1175 during UPDATE in MySQL Workbench
  10. Cannot connect to Database server (mysql workbench)
  11. How to connect mysql workbench to running mysql inside docker?
  12. MySQL Workbench: How to keep the connection alive
  13. How do I retrieve my MySQL username and password?
  14. MySQL select with CONCAT condition
  15. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  16. MySQL error 1022 when creating table
  17. Is there a naming convention for MySQL?
  18. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  19. MySQL concat() to create column names to be used in a query?
  20. MySQL Errno 150
  21. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  22. MySQL CONCAT returns NULL if any field contain NULL
  23. error code 1292 incorrect date value mysql
  24. Order by FIELD in MYSQL
  25. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  26. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  27. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  28. mySQL query to search all tables within a database for a string?
  29. Create a new database with MySQL Workbench
  30. Errno 121, duplicate key on write or update?

Leave a Comment