SELECT comma separeted different values from single column

Asked Aug 27 '19 at 10:01

Active Aug 27 '19 at 10:06

Viewed 28 times

I have 2 tables : How to write SELECT, which show me on web page this result? e.g MAMMALS: ELEPHANT, TIGER (with ',')

Table: Animals:

+-------------+-------------+-------------+
| ANIMAL_TYPE | ANIMAL_CODE | ANIMAL_NAME |
+-------------+-------------+-------------+
| MAMMALS     | 1           | ELEPHANT    |
| MAMMALS     | 2           | TIGER       |
| FISH        | 3           | CARP        |
| FISH        | 4           | SHARK       |
+-------------+-------------+-------------+

Table: Child

+------------+----------------+-------------+
| CHILD_NAME | ANIMAL_MAMMALS | ANIMAL_FISH |
+------------+----------------+-------------+
| ANNA       | 1,2            | 3           |
| WOJTEK     | 2              |             |
| DAWID      | 1              | 3,4         |
| ROBERT     |                | 4           |
+------------+----------------+-------------+

RESULT ON WEB PAGE:

NAME: ANNA MAMMALS: ELEPHANT, TIGER FISH: CARP

NAME: ROBERT MAMMALS: FISH: SHARK

edited Aug 27 '19 at 10:06

Strawberry

33,750
13
40
57

asked Aug 27 '19 at 10:01

Anka1

what you have tried so far, can you please post your code snippet. – DarkRob Aug 27 '19 at 10:03
This is really a bad DB design. Never store the comma separated values in DB. It violates the 1NF rule. – Ankit Bajpai Aug 27 '19 at 10:03
I know that this is bad DB design, but this is requirement for questionnaire – Anka1 Aug 27 '19 at 10:12
Comment does not compute. – Strawberry Aug 27 '19 at 10:34
Try using mysql group_concat function and group by ANIMAL_TYPE – Vibhas Aug 27 '19 at 16:50

SELECT comma separeted different values from single column

0 Answers0