PHP MySQL search word if %100 equals to word I searched "bat" and I saw "batman" in results : <p>PHP MySQL search word if %100 equals to word I searched "bat" and I saw "batman" in results. I just want to list if title contains "bat", I dont want to list if contains "batman"</p>

<p>I'm tried many way. I can't solve this problem. How can be solve this problem? I can't understand why result like that. This code in the below. Thanks for your advice from now.</p>

<pre><code>$sql = "SELECT * FROM `tablename` WHERE `title` LIKE '%bat%' ORDER BY RAND() LIMIT 30;";
</code></pre>
