title: PostgreSQL ILIKE on concatinated columns not working
body: <p>I'm trying to query using ILIKE on a user's name in PostgreSQL.  There are columns for first_name and last_name, and I'd like the search term to match against the two concatenated, with a space between, so that a user may search for either, or a full name using one input.  "John"  "Doe" or "John Doe".</p>
  
  <p>This always returns no results:</p>
  
  <p><code>SELECT * FROM user_profiles WHERE first_name || ' ' || last_name ILIKE '%ryan%'</code></p>
  
  <p>This always returns the one result I am expecting:</p>
  
  <p><code>SELECT * FROM user_profiles WHERE first_name ILIKE '%ryan%'</code></p>
  
  <p>Based on everything I've read, the first query should work as I am expecting, but it doesn't.  No results and no errors.  What am I missing here?</p>