title: How to use bindings in a whereRaw query?
body: <p>I have a table with two columns, 'first_name' and 'last_name' and I want to join both tables so that I can search a query against them with a LIKE query and using % wildcards.</p>
  <p>I was able to do this when I used a string literal, however it is not working when I'm trying to use positional bindings. I am returned with nothing.</p>
  <p>Is there a way to join the two columns without concat and a whereRaw function? And how would I write the binding correctly?</p>
  <pre><code>const searchUser = (query) =&gt; {
    const name = query.toLowerCase();
    return knex('users')
      .select('*')
      .whereRaw('concat(LOWER(&quot;first_name&quot;), \' \' , LOWER(&quot;last_name&quot;)) LIKE \'%??%\'', [name]);
  };
  </code></pre>