Php string replacement method

Using the explode function, use the string to be replaced as the separator, connect the two array elements to the string to be replaced, and then UPDATE the array for the past few days, A small problem occurs during work. one field of the content type is stored in a language, because the data written is imported in Excel, so in order to make the processing simple, many languages are separated by commas (,) to create a string for all languages, which is much simpler to store. However, due to the original data quality problems, some of the "Chinese" are "Mandarin Chinese". now we need to change all "Mandarin Chinese" to "Chinese ".
This requires replacement of some strings in a string. To solve this problem, we usually use regular expressions for replacement or some replacement methods in PHP. it is very troublesome and time-consuming to do so, so I thought of such a lazy method, using the explode function, using the string to be replaced as the separator, and then connecting the two array elements to the string to be replaced, then UPDATE it.
Copy codeThe code is as follows:
Function replace (){
$ SQL = db_query ("SELECT field_languages_value, nid FROM {content_type_company_profile} WHERE

Field_cmdages_value like '% Mandarin Chinese % '");
While ($ result = db_fetch_object ($ SQL )){
$ A = explode ("Mandarin Chinese", $ result-> field_languages_used_value );
$ B = $ a []. 'China'. $ a [1];
Db_query ("UPDATE content_type_company_profile SET field_languages_used_value = '% s' WHERE nid = %

D ", $ B, $ result-> nid );
}
}
?>