case insensitive where mysql knex code example Example: knexjs search uppercase qb.whereRaw(`LOWER(name) LIKE ?`, [`%${search}%`])