Category Technology

Parsing and Joining on a Long Text Field Using SQL

Share

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…

Share