CONCAT function in mysql

CONCAT function in mysql

This function is used to concat the string with the specified field.

Example
$str = “.com”
UPDATE user SET email = CONCAT(email,’$str’) WHERE userid = 1

In the above example we concat $str with the email field.

Leave a Reply


All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.