title: Select a particular record from identical records in a MySQL database
body: <p>I have a table like this:</p>
  
  <pre><code>+---------+---------+-----------------------------------------+
  | type    | city    | name                                    |
  +---------+---------+-----------------------------------------+
  | cricket | kolkata | Khadim's Ashok Malhotra Cricket Academy |
  | cricket | kolkata | Calcutta Cricket Coaching Center (C4)   |
  | cricket | kolkata | Sambaran Banerjee Cricket academy       |
  | cricket | kolkata | Bournvita cricket acadamemy of arun lal |
  | cricket | kolkata | friends of the stadium                  |
  | cricket | kolkata | pankaj roy cricket academy              |
  | cricket | kolkata | sunil gavaskar cricket foundation       |
  | cricket | kolkata | castlewood india                        |
  | cricket | kolkata | GK sports                               |
  | cricket | kolkata | NULL                                    |
  | cricket | kolkata | NULL                                    |
  | cricket | kolkata | NULL                                    |
  | cricket | kolkata | NULL                                    |
  | cricket | kolkata | NULL                                    |
  | cricket | kolkata | NULL                                    |
  +---------+---------+-----------------------------------------+
  </code></pre>
  
  <p>I want to give different names instead of <code>NULL</code>, how can I do this?</p>