title: Node Sequelize find where $like wildcard
body: <p>I am trying to add a where like clause to a Node Sequelize findAll, to behave like the sql query <code>select * from myData where name like '%Bob%'</code> with the below code</p>
  
  <pre><code>let data: Array&lt;any&gt; = await MyDataSequelizeAccess.findAll({
    where: {
      name: {
        $like: `%Bob%`
      }
    }
  });
  </code></pre>
  
  <p>Which is returning the below error</p>
  
  <blockquote>
    <p>Invalid value { '$like': '%Bob%' }</p>
  </blockquote>
  
  <p>How can I perform that type of where wildcard or where like on my sequelize object?</p>
  
  <pre><code>let data: Array&lt;any&gt; = await MyDataSequelizeAccess.findAll({
    where: {
      name: `Bob`
    }
  });
  </code></pre>
  
  <p>This works as expected, but I cannot get the wildcard to work.</p>
  
  <p><em>updated</em> still no dice - per <a href="https://sequelize.readthedocs.io/en/latest/docs/querying/#operators" rel="noreferrer">https://sequelize.readthedocs.io/en/latest/docs/querying/#operators</a> my syntax looks correct</p>
  
  <p>I'm also trying (and failing) to do the same with $not as in</p>
  
  <pre><code>let data: Array&lt;any&gt; = await MyDataSequelizeAccess.findAll({
    where: {
      name: {
        $not: `Bob`
      }
    }
  });
  </code></pre>
  
  <p>and getting the same error as above <code>Invalid value { '$not': '%Bob%' }</code></p>