title: How to search SQL column containing JSON array
body: <p>I have a SQL column that has a single JSON array:</p>
  
  <pre><code>{"names":["Joe","Fred","Sue"]}
  </code></pre>
  
  <p>Given a search string, how can I use SQL to search for a match in the names array?  I am using SQL 2016 and have looked at JSON_QUERY, but don't know how to search for a match on a JSON array.  Something like below would be nice.</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE JSON_QUERY(column, '$.names') = 'Joe'
  </code></pre>