MySql中截取字符串中的某几个字符

2025-03-22 18:35:49
推荐回答(2个)
回答1:

更新?是插入动作吧?还是说已经存在记录了?
--------------下面的字段对应应该没错吧?
system对应jobtype
company_id对应cid
installer_id对应installerid
installer_config_id对应configid

回答2:

mysql> SELECT -> SUBSTRING('G3_555', INSTR('G3_555', '_') + 1);+------------------------------------------------+| SUBSTRING('G3_555', INSTR('G3_5