SQL code to get GRAM job ID from URL


mysql> use techx;
mysql> select trim(trailing '.' from replace(substring_index(gridJobID, '/', -3), '/', '.')) as 'gram_id' from Jobs;

+---------------------+
| gram_id |
+---------------------+
| 14094.1226615002 |
| NULL |
| 16255.1226616087 |
| 19674.1226619065 |
| 22903.1226620711 |
| 28114.1226625017 |
| 29889.1226625489 |
| NULL |
| 11191.1226683572 |
| 25930.1226693279 |
| 30603.1226697028 |
| 7016.1226699246 |
+-------------------- -+
12 rows in set (0.00 sec)