title: Postgres: How to string pattern match query a json column?
body: <p>I have a column with json type but I'm wondering how to select filter it i.e. </p>
  
  <pre><code>select * from fooTable where myjson like "orld";
  </code></pre>
  
  <p>How would I query for a substring match like the above. Say searching for "orld" under "bar" keys?</p>
  
  <pre><code>{ "foo": "hello", "bar": "world"}
  </code></pre>
  
  <p>I took a look at this documentation but it is quite confusing.</p>
  
  <p><a href="https://www.postgresql.org/docs/current/static/datatype-json.html" rel="nofollow noreferrer">https://www.postgresql.org/docs/current/static/datatype-json.html</a> </p>