This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

how add string on value of result on mysql mariadb

dear Mr. / Mrs.

how add string on value of result on mysql mariadb ?

Thank you Agustino Design buana

Answer Answered by Jan Steinman in this comment.

Have you looked at the manual page for CONCAT()? It returns a string formed by concatenating its arguments.

So you could do (for example)

SELECT
   CONCAT(value_of_result, " string to be added")
   FROM some_table

where "value_of_result" is a field in the table "some_table".

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.