Database structure for multiple values

Question

I have the following database structure:

categories:

    cat_id |   name
    -------+--------
         1 | test 1
         2 | test 2

date:
    id |   text | cat_id
    ---+--------+--------
     1 | google |      1
     2 |     fb |      2
     3 |  yahoo |    1,2

I want to display "yahoo" in both categories. I know it's not good to store two values in the same cell. My last idea is to insert two rows with same text but different cat_id.

Is there any other way to do this?

Answer 1

You can have it like this:

categories:

cat_id |   name
-------+--------
     1 | test 1
     2 | test 2

date:

id |   text | cat_id
---+--------+--------
 1 | google |      1
 2 |     fb |      2
 3 |  yahoo |      1
 4 |  yahoo |      2