CODEWITHSUNDEEP
mysqlnode.jssequelize.jssql-like
Pritesh Mahajan
Pritesh Mahajan

Reputation: 5154

Sequelize LIKE is not working with WHERE clause

I am using Sequelize with Node. Below i my code. Like condition is not working with where condition. I am trying to add search by company name. 

   let err, company;
   console.log(req.body);
   [err, company] = await to(Company.findAll({where : {company_name:{ $like: '%'+req.body.q+'%' }}}));  
   if(err){ return ReE(res, err); } 
   console.log(' company -------------- ',err);

I am getting below error. 

{ q: 'abc' }
 company --------------  { filename:
'/MYPATH/node_modules/sequelize/lib/sql-string.js',
  line: 51,
  row: 11,
  message: 'Invalid value { company_name: { \'$like\': \'%abc%\' } }',
  type: 'Error',
  stack:
   'Error: Invalid value { company_name: { \'$like\': \'%abc%\' } }\n    
   at Object.escape (/MYPATH/node_modules/sequelize/lib/sql-string.js:51:11)\n   
   at Object.escape (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:927:22)\n   
   at Object._whereParseSingleValueObject (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2396:41)\n   
   at Object.whereItemQuery (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2096:21)\n    
   at Utils.getComplexKeys.forEach.prop (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1957:25)\n    
   at Array.forEach (<anonymous>)\n    
   at Object.whereItemsQuery (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1955:35)\n    
   at Object.getWhereConditions (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2423:19)\n    
   at Object.selectQuery (/MYPATH/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1133:28)\n   
   at QueryInterface.select (/MYPATH/node_modules/sequelize/lib/query-interface.js:1077:27)\n    
   at Promise.try.then.then.then (/MYPATH/node_modules/sequelize/lib/model.js:1596:34)\n    
   at tryCatcher (/MYPATH/node_modules/bluebird/js/release/util.js:16:23)\n   
   at Promise._settlePromiseFromHandler (/MYPATH/node_modules/bluebird/js/release/promise.js:512:31)\n    
   at Promise._settlePromise (/MYPATH/node_modules/bluebird/js/release/promise.js:569:18)\n    
   at Promise._settlePromise0 (/MYPATH/node_modules/bluebird/js/release/promise.js:614:10)\n    
   at Promise._settlePromises (/MYPATH/node_modules/bluebird/js/release/promise.js:693:18)\n    
   at Async._drainQueue (/MYPATH/node_modules/bluebird/js/release/async.js:133:16)\n    
   at Async._drainQueues (/MYPATH/node_modules/bluebird/js/release/async.js:143:10)\n    
   at Immediate.Async.drainQueues [as _onImmediate] (/MYPATH/node_modules/bluebird/js/release/async.js:17:14)\n    
   at runCallback (timers.js:705:18)\n    at tryOnImmediate (timers.js:676:5)\n    at processImmediate (timers.js:658:5)',
  arguments: undefined }

Upvotes: 1

Views: 3289

Answers (2)

Ashu
Ashu

Reputation: 357

I had the same issue, initially sequelize version was 5.22.3 after getting above error i changed to ^4.38.0.

Working without any error. Hope this will help someone.

Upvotes: 0

Muhammed
Muhammed

Reputation: 51

Add const Op = Sequelize.Op; at the top of file and import 'Sequelize' to the file.

import { Sequelize } from 'sequelize';

const Op = Sequelize.Op;

const companies = await to(Company.findAll({where : {company_name:{ [Op.like]: '%'+req.body.q+'%' }}}));
return companies;

Upvotes: 4

Related Questions