SQL find rows where column is LIKE
<p>I want to find rows that have a particular name on it. Problem is that some of the rows have a prefix: <code>"(OBSOLETE)"</code> or <code>"(OBSOLETE) "</code></p>

<p>So for the name John, I could have three rows:</p>

<pre><code>John
(OBSOLETE)John
(OBSOLETE) John
</code></pre>

<p>How would I write a query so that I can find all the rows that match that name knowing that sometimes a prefix will be there, and I also want those?</p>