4 Replies Latest reply: Apr 3, 2015 8:52 AM by Sergey Yakimchuk RSS

    Work with data in a single field, separated by comma

    Sergey Yakimchuk

      Good day,

      there are 2 tables

      1) the list of services


      id_service; - service code

      name_service; - name of the service


      2) the journal of services rendered


      id; - code recording

      id_service; - service code


      The problem is that the developer stores data about the list of services separated by commas in a single field



      id; id_service

      1; [1]

      2; [1,2,3,4]

      3; [2,1,2]



      1) how can you count the number of services?

      2) how you can substitute the name of the service?


      Thank you for your attention