How to delete data next to Underscore in my sql

Feb 13 2017 2:10 AM

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.

Answers (3)

Reason of output