title: ILIKE Match Word Boundaries PostgreSQL 9
body: <p>When using the LIKE/ILIKE operator in PostgreSQL 9 is it possible to match word boundaries without having to use full blown ~ operator regular expressions?</p>
  
  <p>For example</p>
  
  <pre><code>SELECT 'Super fast training' ILIKE '%train\M%' as match; 
  </code></pre>
  
  <p>Where \M is the boundary at the end of a word and match returns <strong>false</strong></p>
  
  <p>Thanks,</p>
  
  <p>Mark</p>