UPDATE game SET g_game_path = REPLACE(g_game_path,”s1.g”,”um”);

For the query above, is to update the “game” table , to replace g_game_path’s “s1.g” into “um”