title: Why is my postgreSQL query not finding the correct object from my table?
body: <p>I'm getting stuff like == is not a symbol and command not found. What is the correct way to select a user by email?
  This is my table schema:</p>
  <pre><code>-- Your database schema goes here --
  
  -- USERS TABLE --
  DROP TABLE IF EXISTS users;
  CREATE TABLE users(userAccount jsonb);
  
  -- SECRETS TABLE --
  DROP TABLE IF EXISTS secrets;
  CREATE TABLE secrets(secrets jsonb);
  
  </code></pre>
  <p>This is my populated table:</p>
  <pre><code>-- USERS TABLE POPULATION --
  DELETE FROM users;
  INSERT INTO users VALUES ('{&quot;name&quot;:&quot;Jack Cooper&quot;,&quot;password&quot;:&quot;banana&quot;,&quot;email&quot;:&quot;jc@gmail.com&quot;,&quot;role&quot;:&quot;admin&quot;}');
  INSERT INTO users VALUES ('{&quot;name&quot;:&quot;Emmanuel Pena&quot;, &quot;password&quot;:&quot;potato&quot;, &quot;email&quot;:&quot;ep@gmail.com&quot;, &quot;role&quot;: &quot;admin&quot;}');
  </code></pre>
  <p>The queries I have tried are:</p>
  <pre><code>SELECT userAccount FROM users WHERE userAccount-&gt;'email' ~* $1
  SELECT userAccount FROM users WHERE userAccount-&gt;'email' LIKE $1
  SELECT userAccount FROM users WHERE userAccount-&gt;'email' = $1
  SELECT userAccount FROM users WHERE userAccount-&gt;'email' == $1
  </code></pre>