mysql substring_index

select * from table;

select substring_index(column,":",2) from table;

select position(':' in column) from table;

select substring(column,position(':' in column),5) from table;