Parsing and Joining on a Long Text Field Using SQL

Here’s a little SQL gymnastics used to parse and query against a predictably-formatted long text field. The challenge: We have a single text field that contains a list person_id-to-area mappings, and we need the query the database for a list…