I have JSON data that looks like this: 
{
   "People" : [
      {
         "name" : "bob",
         "title" : "janitor",
         "email" : "taco@blah.com",
         "iq" : "180",
         "favorite_food" : "wagyu steak"
      },
      {
         "name" : "joe",
         "title" : "software engineer",
         "email" : "",
         "iq" : "80",
         "favorite_food" : "raw hamburger"
      },
      {
         "name" : "sandy",
         "title" : "dishwasher",
         "email" : "",
         "iq" : "240",
         "favorite_food" : "tacos"
      },
      {
         "name" : "george",
         "title" : "software engineer",
         "email" : "",
         "iq" : "14",
         "favorite_food" : "tacos"
      }
   ]   
}

[download]
I am trying to filter this data in such a way that it returns any arrays whose values (any value) matches a word. So, using the above example, say that someone was to want to filter this out on the word taco, that filter would return this: 
{
   "People" : [
      {
         "name" : "bob",
         "title" : "janitor",
         "email" : "taco@blah.com",
         "iq" : "180",
         "favorite_food" : "wagyu steak"
      },
      {
         "name" : "sandy",
         "title" : "dishwasher",
         "email" : "",
         "iq" : "240",
         "favorite_food" : "tacos"
      },
      {
         "name" : "george",
         "title" : "software engineer",
         "email" : "",
         "iq" : "14",
         "favorite_food" : "tacos"
      }
   ]   
}

[download]
It returned anything where a value matches "taco." Think of it like this: Each key/value pair is a column in a SQL table, and I am trying to say 
SELECT * FROM People WHERE name = 'taco' OR title = 'taco' OR email = 
+'taco' OR iq = 'taco' OR favorite_food eq 'taco';

[download]
I'd really like to do this matching with grep, but just knowing how to do it at all will be a start in the right direction (if it is possible).

In reply to Need something like a SQL query for JSON data structures (JSON::XS) by walkingthecow

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.