Can you please help me this.
I’ve written this sql query to extract only course name in english, removing mlang strings and hindi words. There are 2 {mlang} coming in my code after this code,
SELECT TRIM(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(fullname,'{mlang en}’,”),
‘{mlang}’,”),'{mlang hi}’,”),
‘टीम माईटी सक्षम की यात्रा से जुड़े!’,
‘ ‘ ),
‘ {mlang} {mlang}’,”),
‘{mlang}’,
”
)
) as
fullname FROM prefix_course
reference string
{mlang en}Join Team Mighty Saksham in their Journey!{mlang}{mlang hi}टीम माईटी सक्षम की यात्रा से जुड़े!{mlang}
Pls let me know for any queries.
Thank you