How to delete data next to Underscore in my sql

Question

Hello Friends,

 

I am getting error  in delete query could you please help me?

 

my question is - I  have land_mark  field in that data is like  1251-Peripheral_Rd_2_Blore

i want to remove data from  _ to next all data like  in that filed i need to delete  _Rd_2_Blore

from  land_mark field and i want Answer like  1251-Peripheral

 

Please tell  me how to write query  for above issue.