title: LIKE query with wildcard in TypeORM QueryBuilder
body: <p>In my NestJS project I have this TypeORM query:</p>
  
  <pre><code>const users = await this.usersRepository.find({
    skip,
    take,
    order: sortingObject,
    join: {
        alias: 'user',
        leftJoinAndSelect: {
            country: 'user.country_id',
        },
    },
  });
  </code></pre>
  
  <p>Now I only want to return the users with <code>John</code> in there name. In SQL this would be a <code>LIKE</code> query <code>LIKE %John%</code>.</p>
  
  <p>In <a href="https://github.com/typeorm/typeorm/blob/master/docs/find-options.md" rel="nofollow noreferrer">https://github.com/typeorm/typeorm/blob/master/docs/find-options.md</a> there is no information about wildcard <code>LIKE</code> queries.</p>
  
  <p><a href="https://stackoverflow.com/questions/47814537/how-to-perform-a-like-query-typeorm">How to perform a like query Typeorm</a> gives as a solution:
  <code>
  .where("user.firstName like :name", {name: '%' + firstName + '%' })
  </code></p>
  
  <p>But then I am unable to use <code>skip</code> and <code>take</code> which is available when using <code>where()</code> instead of <code>find()</code>.</p>
  
  <p>Any thoughts on how I achieve this with the TypeORM QueryBuilder?</p>