title: How To find Exact string match within a String in Oracle
body: <p>I have an oracle table that has a column called system_access that has the following data:</p>
  
  <pre><code>Read Only, Write, read only, Admin
  Read, Write, read only, Admin
  Admin, Read Only (no), read only(see mgr), Admin
  </code></pre>
  
  <p>Based on the above sample data, I am unsure of my query to only retrieve records that match the exact words of "Read Only" and/or "read only"</p>
  
  <p>I do not need the records that have the "Read Only (no)" with space then bracket after it or before it or "read only(see mgr)" with no space and bracket after it or before it.</p>
  
  <p>So based on above sample data, I would only get back two rows only, i.e.:</p>
  
  <pre><code>Read Only, Write, read only, Admin
  Read, Write, read only, Admin
  </code></pre>
  
  <p>As mentioned, only records that match exactly the string "Read Only" or "read only"</p>