ST_CONTAINS

1
SELECT ST_CONTAINS(
2
  ST_GEOGFROMTEXT('POLYGON((106 -7, 107 -7, 107 -6, 106 -6, 106 -7))'),
3
  ST_GEOGPOINT(106.5, -6.5)
4
) AS is_inside;

1
SELECT user_id,
2
  CASE
3
    WHEN ST_CONTAINS(service_area, user_location) THEN 'In Service Area'
4
    ELSE 'Outside'
5
  END AS status
6
FROM users
7
CROSS JOIN service_zones;