title: Postgres concatenate regex and table column
body: <p>I would like to run the query</p>
  
  <pre><code>SELECT * FROM table_a JOIN table_b ON table_a.title LIKE ('^[a-b]' || table_b.title)
  </code></pre>
  
  <p>where if table_a.title = "the foo bar", and table_b.title has a row named "oo", the query will not return any results, but if table_b.title has a row named "foo", it will return results.</p>
  
  <p>Basically I want to match the title on table_b only if it is an entire word (surrounded by spaces, or at the beginning and end of string) but not if another word has a part of table_b.title in it.</p>
  
  <p>Any ideas?</p>