SQL: How to connect function to a string

Question

Is there any way to connect function to a string?

Like this:

UPDATE table SET col = 'MYSTRING' . SUBSTRING_INDEX(col, ':', 2)

Thanks in advance.

Answer 1

Are you looking for concat()?

UPDATE table
    SET col = CONCAT('MYSTRING', SUBSTRING_INDEX(col, ':', 2));