title: SQL issue with using concatenation inside "like"
body: <p>I'm trying to use subquery inside &quot;like&quot;, sth like this:</p>
  <pre><code>select * 
  from message c  
  where c.content like (select concat('%', value, '%') 
                        from objects o 
                        where o.orderid = '70008090102484');
  </code></pre>
  <p>and it's returning no results. When I copy paste the output of the select instead of it, it returns one row, so I've tried this:</p>
  <pre><code>select * 
  from message c  
  where c.content like concat('%', '123', '%'); - no results
  
  select * 
  from message c  
  where c.content like '%123%';* - 1 result
  </code></pre>
  <p>I've tried with '%' || '123' || '%' and the same result.
  Does anybody have any idea why this is happening?</p>
  <p>EDIT: &quot;content&quot; field is of type &quot;bytea&quot; - for varchar it works fine, unfortunately, I'm unable to change this field type</p>