-
-
Notifications
You must be signed in to change notification settings - Fork 4.3k
Closed
Description
Hello. I have a problem in postgresql using ILIKE
db.companies.findAll({where: {name: {$iLike: "%"+name+"%"}}}).then(function(companies) {
callback(companies)
}).catch(function(error) {
throw error;
})
generates this SQL
SELECT "id", "name", "city", "sphere", "founder", "accountType", "visible", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."name" '%z%';
and I always get an error because of ILIKE: Possibly unhandled SequelizeDatabaseError: error: schema "companies" does not exist
Metadata
Metadata
Assignees
Labels
No labels