title: search in json type coloumn in psotgreSql
body: <p>i have a json like this</p>
  
  <pre><code>   {
         "dbInfo":{
            "id":"F",
            "lifeTime":"ACTIVE"
         },
         "name":{
            "firstName":"abc",
            "lastName":"xyz"
         },
         "contactDetails":{
            "email":{
               "localPart":"abc",
               "domain":"gmail.com"
            },
            "mobile":[
               {
                  "code":"ISD_91",
                  "number":"9658321407"
               }
            ]
         },
         "type":{
            "personType":"WORKER"
         }
      }
  </code></pre>
  
  <p>i want to perform search in database Where is a 
  <code>number = 9658321407</code> 
  it will return the whole json to me in postgresql database can anybody help me to write my query i want to get all json those have this number and how i search if i have more then one number</p>