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.

If you're using MySQL, Gordon Linoff has the answer. But your mysql tag may have been added automatically by Stack Overflow. If you use some other RDBMS, the syntax varies. See blog.mclaughlinsoftware.com/2009/03/09/sql-concatenation-blues — Bill Karwin
– Bill Karwin, Commented Sep 23, 2017 at 18:30

Gordon Linoff · Accepted Answer · 2017-09-23 18:14:32Z

1

Are you looking for concat()?

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

answered Sep 23, 2017 at 18:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1