1 2 3 4 5 6 7 8 9 10 11 12 13 14
| --------------
select SUBSTRING_INDEX(SUBSTRING_INDEX('612.3.7091.21078','.',1),'.',-1) as Num1,
SUBSTRING_INDEX(SUBSTRING_INDEX('612.3.7091.21078','.',2),'.',-1) as Num2,
SUBSTRING_INDEX(SUBSTRING_INDEX('612.3.7091.21078','.',3),'.',-1) as Num3,
SUBSTRING_INDEX(SUBSTRING_INDEX('612.3.7091.21078','.',4),'.',-1) as Num4
--------------
+------+------+------+-------+
| Num1 | Num2 | Num3 | Num4 |
+------+------+------+-------+
| 612 | 3 | 7091 | 21078 |
+------+------+------+-------+
Appuyez sur une touche pour continuer... |
Partager