mysql substring_index

select * from tablename where substring_index(field1,'_',-1)=‘abc'

 

#表中field1的值结构为123_abc