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.
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.