Assuming fieldtochange is required, the following result was found.
with the string you want to replace with -- REPLACE FROM A STARTING POINT -- Read-Only (see changes to commit) SELECT a.`fieldtochange`, SUBSTRING(a.`fieldtochange`, INSTR(a.`fieldtochange`, 'stringtofind') ) FROM `v34_mytablename` a WHERE...