Equals updates only part of a cell

If I have a long string inside of a cell, lets say

UPDATE gtdb set camelot = '7A' WHERE major_key = 'D Minor'

Can I have excel use the Equals function on only part of the string? like this

(D Minor) = A13

Thanks for your help