Q:

Mysql query to find the blank word by comparing 2 sentences

I have 2 fields in one mysql table.
One field has full sentence and another field has the same sentence but with one word replaced by "_". How I can find the replaced word using mysql query?
Example:
Field1: We aim for an 85% success rate.
Field2: We _ for an 85% success rate.
I need a query which can find the word "aim" comparing both 2 sentences.

A:

SELECT REVERSE(
         SUBSTR(
           REVERSE(SUBSTR(Field1 FROM INSTR(Field2, '_')))
         FROM
           INSTR(REVERSE(Field2), '_'))
       )
FROM table

