i have this table in my data base any client subscribe with the same card number is add in the same row with an update in client_id column like this :
| card_Num | Client_id |
|---|---|
| 0000111 | 1,2,3,.....N |
i have to list my client like this and i dont have any idea of number of occurence COLUMN CLIENT_ID IS UPDATE EVERY NEW SUBSCRIPTION IT ADD A NEW CLIENT_ID:
| card_Num | Client_id |
|---|---|
| 0000111 | 1 |
| 0000111 | 2 |
| 0000111 | 3 |
| 0000111 | 4 |
| 0000111 | N |
i try to join name and number of client to card number with mysql
