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;
mysql substring_index
最新推荐文章于 2024-09-25 11:06:23 发布
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;