I have two columns in my mysql table, equipment
and orderno
, Here equipment number is manually inserted, and they are in the form C1234
,C3212
etc.
I want to strip the C
from equipment
column and insert the remaining number to orderno
column. I have seen that mysql substring_index()
can effectively get substring but I am not sure how to make it automtically do the changes, when the equipment
column changes.