title: Query case insensitive with Sequelize in Node using MariaDB database
body: <p>I'm new in Sequelize and after digging a lot I could not find a way to write a query using <em>LOWER</em> and <em>LIKE</em> at the same time. </p>
  
  <p>I want to write something like:</p>
  
  <pre><code>SELECT * 
    FROM acessories
   WHERE LOWER(name) LIKE '%xyz%' 
      OR LOWER(description) LIKE '%xyz%'
   ORDER BY name
  </code></pre>
  
  <p>I wrote the code like this, but I can't use the LOWER function:</p>
  
  <pre><code>const getAcessories = await Acessories.findAndCountAll({
          limit,
          offset: start,
          order: [["name", "ASC"]],
          where: {
            [Sequelize.Op.or]: [
              {
                name: {
                  [Sequelize.Op.like]: `%${search}%`
                },
                description: {
                  [Sequelize.Op.like]: `%${search}%`
                }
              }
            ]
          }
        });
  </code></pre>
  
  <p>Edit: Creation table command:</p>
  
  <p>select * from atm_usuarios;</p>
  
  <pre><code>CREATE TABLE `acessories` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `store` int(11) NOT NULL,
    `in_value` decimal(10,2) NOT NULL,
    `out_value` decimal(10,2) NOT NULL,
    `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime DEFAULT NULL,
    `deleted_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 collate=utf8_general_ci ROW_FORMAT=DYNAMIC;
  </code></pre>
  
  <p>Any help?</p>