MySQL : Selecting count of mutiple enum value
<p>I am making a movie rating application where a user can rate a movie as either 'like' or 'dislike'. So I have made 3 tables user, movie and rating. The vote table's example is : </p>

<pre><code>userID    movieID     Vote

 x        a           li
 y        a           dli
 y        b           li
 w        a           li
</code></pre>

<p>The table's schema is :</p>

<pre><code>userID - PrimaryKey
movieID - PrimaryKey
Vote - Enum('li','dli')
</code></pre>

<p>I have made userID and movieID as primary key so that if the user updates his/her preference that specific row gets updated if the record is there. </p>

<p>Edit : Here's the movie table's schema.</p>

<pre><code>mID - PrimaryKey
mName - Varchar
mGenre - Varchar
mDesc -  Text
mDateOfRelease - Date
</code></pre>

<p><strong>My question is that is it possible to select all the columns from the movie table, and like and dislike count of that movie in one db call. If yes how can I do it?</strong></p>