I have 2 tables, CONTENT Table and CONTENT_DETAIL Table, in my CONTENT Table it has contentId & articleId columns, in CONTENT_DETAIL Table, it has contentId & content(BLOB) columns. i want to update content column in CONTENT_DETAIL table that the content column contains string in pattern ABC_123456 (6 random digits with ABC_ prefix, the 6 digits will match with the articleId in CONTENT Table) and replace the ABC_123456 with contentId in CONTENT table, how can i do?

Would appreciate if anyone could help, thank you in advance.