How can i get middle values in particular column in SQL

Question

How can i get middle values in particular column in SQL 5.6, MySQL Workbench ie :

5014.**160201**.1200.1-2 here i need the value **160201**

What does "middle value" mean? Do all values follow the same form: A.B.C.D-E? — Gordon Linoff, Sep 21 '18 at 13:00
No, It is like A.B.C.#### # INDICATES any value like D-E or D.E or D — Kishore, Sep 21 '18 at 13:42

score 1 · Accepted Answer · answered Sep 21 '18 at 13:01

1

You can get the second value, based on the period separator, using substring_index():

select substring_index(substring_index(col, '.', 2), '.', -1) as second_part

answered Sep 21 '18 at 13:01

Gordon Linoff

Thanks that worked, Can u explain to me how that work. – Kishore Sep 21 '18 at 13:30
@Kishore . . . https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_substring-index. – Gordon Linoff Sep 21 '18 at 16:56
thank you so much for your valuable reference @Gordon Linoff – Kishore Sep 24 '18 at 07:17

1 Answers1