使用PHP或MySql从其他人的结果创建一个新的MySql列

Question

I have this situation:

    NAME    |    SURNAME    |    RANK
  JASMINE     VISMITANANDA        4
  JASMINE     VISMITANANDA        6

And I would love to obtain this situation using MySql and / or PHP

NAME    |    SURNAME    |    RANK
JASMINE     VISMITANANDA      4 - 6

There's a way to do it without looping too much with PHP?

Answer 1

You can use a group by. This might do what you want:

select name, surname, concat_ws(' - ', min(rank), max(rank)) as rank
from table t
group by name, surname;