Move "The" to the end of a column

gistfile1.txt

UPDATE games
     SET title = CASE WHEN INSTR(title,' ')>0 
             AND LEFT(title,INSTR(title,' '))
              IN ('The ')
            THEN CONCAT(UPPER(SUBSTRING(title,INSTR(title,' ')+1,1))
                       ,SUBSTRING(title,INSTR(title,' ')+2)
                       , ', '
                       , LEFT(title,INSTR(title,' ')-1))
            ELSE title
        END