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