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

       

      Example:

      id; id_service

      1; [1]

      2; [1,2,3,4]

      3; [2,1,2]

       

      Questions

      1) how can you count the number of services?

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

       

      Thank you for your attention