title: Sequelize: Find All That Match Contains (Case Insensitive)
body: <p>I want to use sequelize.js to query a model for records with a contains restraint. How do I do that?</p>
  
  <p>This is what I have right now:</p>
  
  <pre><code>Assets
    .findAll({ limit: 10, where: ["asset_name like ?", '%' + request.body.query + '%'] })
    .then(function(assets){
      return response.json({
        msg: 'search results',
        assets: assets
      });
    })
    .catch(function(error){
      console.log(error);
    });
  </code></pre>
  
  <p>but I get the following error:</p>
  
  <pre><code>   { error: operator does not exist: character varying @&gt; unknown
         at Connection.parseE (/home/travellr/safe-star.com/SafeStar/node_modules/pg/lib/connection.js:554:11)
         at Connection.parseMessage (/home/travellr/safe-star.com/SafeStar/node_modules/pg/lib/connection.js:381:17)
         at Socket.&lt;anonymous&gt; (/home/travellr/safe-star.com/SafeStar/node_modules/pg/lib/connection.js:117:22)
         at emitOne (events.js:96:13)
         at Socket.emit (events.js:188:7)
         at readableAddChunk (_stream_readable.js:176:18)
         at Socket.Readable.push (_stream_readable.js:134:10)
         at TCP.onread (net.js:548:20)
       name: 'error',
       length: 209,
       severity: 'ERROR',
       code: '42883',
       detail: undefined,
       hint: 'No operator matches the given name and argument type(s). You might need to add explicit type casts.',
       position: '246',
       internalPosition: undefined,
       internalQuery: undefined,
       where: undefined,
       schema: undefined,
       table: undefined,
       column: undefined,
       dataType: undefined,
       constraint: undefined,
       file: 'parse_oper.c',
       line: '722',
       routine: 'op_error',
       sql: 'SELECT "id", "asset_name", "asset_code", "asset_icon", "asset_background", "asset_add_view", "asset_add_script", "asset_add_id_regex", "date_created", "uniqueValue", "createdAt", "updatedAt" FROM "assets" AS "assets" WHERE "assets"."asset_name" @&gt; \'%a%\' LIMIT 10;' },
    sql: 'SELECT "id", "asset_name", "asset_code", "asset_icon", "asset_background", "asset_add_view", "asset_add_script", "asset_add_id_regex", "date_created", "uniqueValue", "createdAt", "updatedAt" FROM "assets" AS "assets" WHERE "assets"."asset_name" @&gt; \'%a%\' LIMIT 10;' }
  </code></pre>
  
  <p>How do you use a contains query in sequelize?</p>