MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Count Distinct comma separated column.
Posted by: Bramantyo Ariotejo
Date: July 14, 2020 09:15PM

Hi,

Need some help. How to count distinct a column with dynamic comma separated with using regular expressions and without creating functions or procedures. For eg.

Record Display_Id
1 2;4;3
2 2
3 3;4
4 1;3
5 2;3
6 4

Result :
Id Count
1 1
2 3
3 4
4 3

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Count Distinct comma separated column.
Bramantyo Ariotejo
July 14, 2020 09:15PM
Re: Count Distinct comma separated column.
Peter Brawley
July 15, 2020 10:08AM
Re: Count Distinct comma separated column.
Phillip Ward
July 28, 2020 05:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.