naeemqaswar
11/14/2016 - 11:01 AM

Split / Extract columns on ','

Split / Extract columns on ','

SELECT *,
// Extracted column before ',' - 1st column
SUBSTRING_INDEX(`office_coordinates`, ', ', 1) as lat,
// Extracted column after ',' - 2nd column
SUBSTRING(`office_coordinates`, LENGTH(SUBSTRING_INDEX(`office_coordinates`, ', ', 1)) + 2,LENGTH(SUBSTRING_INDEX(`office_coordinates`, ', ', 2))) as lng
from table_name
// if you are intended to use these column_alias in condition use it with keyword HAVING
HAVING lat >= 30.2312 and AND lng >= -80.977272