test

 'abc_id' = Column name
'_id' =  string to be removed

select substr('abc_id', 0, length('abc_id') -  instr('abc_id', '_id') + 1 )  from table_name;