How to use WHERE - LIKE cluase in yii2 and make LIKE pattern search with case sensitivity?
<pre class="lang-php prettyprint-override"><code>$aa = India::find();
$players = $aa
            -&gt;where('player LIKE :query', [':query'=&gt;'S%'])
            -&gt;orderBy('position, player')-&gt;all();
$countnumber = $aa-&gt;count();
</code></pre>

<p>This code returns results without case sensitivity.
Gives results where Player name starts with 'S' or 's'.</p>

<p>But I want to make, just to select Player names only with 'S'.
How to restrict it to select with case sensitivity in PHP Yii2 Framworok ?</p>