INSERT funtion
INSERT funtion
Used to insert a string “i_str” in “s_str” at the ‘pos’ position and ‘len’ length.By using this, we can add common prefix or suffix in the stored data.It returns NULL if any argument is NULL.
Syntax:
INSERT(s_str1,pos,len,i_str)
Example:
update table1 set keyword = insert(keyword, char_length(keyword)+1, 8, ‘_sales_dept’) ;
