title: SQL How to search text field for 2nd without matching 22nd, etc?
body: <p>I want to query for numbered street names that can occur anywhere within a text column, and filter out matches for numbered street names with more digits, i.e. <code>2nd</code> but not <code>42nd</code>, <code>182nd</code>, etc. Is there any method more graceful or simplified than combination of:</p>
  
  <pre><code>WHERE col LIKE '2nd%' OR col LIKE '% 2nd%'
  </code></pre>