mysql regular expression for exact word match
<p>I want regular expression for exact word match for <code>mysql</code> select query. If i have below string from database </p>

<pre><code>string :  my name is amit patel with surname amitnindroda
</code></pre>

<p>Now i want to match whole word <code>amit</code> from above string then it should find exact word <code>amit</code> and it should not find match from <code>amitnindroda</code>. Please suggest regular expression for mysql query</p>