Read phpMyAdmin column with multiple records

Question

I have a table in phpMyAdmin with a field that stores several values, the column is named id_subfilter, I need to read each value of this, because the same are id s that are related to another table the field is a varchar.

The table is this, the field I need to read is what is marked, see:

I couldn’t find anything related to the research I did.

Answer 1

I recommend you do a better modeling of the bank, creating a relational table for this case.

For example, a table between equipment and workers both have an identifier ID, to properly relate to a cardinality N for N relationship, it would be good to create a table equipamentos_trabalhadores where there would be the id_equipamento and the id_trabalhor, this could relate N records, which can be accessed only by id_equipamento or id_trabalhor, thus making access easier and faster.

But if you want to continue with this modeling, you can bring all the data to the programming, or to the query, and use regular expression methods that their use varies depending on the desired programming language.

For using Phpmyadmin I imagine you should use PHP, so I will put a regular expression reference in PHP, but if not this function is available in all languages, follows reference:

http://www.devmedia.com.br/expressoes-regulares-em-php/25076

With this method one can pick up particles from a given text, thus being able to separate the ids who wishes, however, this way is not very suitable for this treatment.

Answer 2

If the goal is to make a JOIN with another table, Mysql offers a shortcut which is the function FIND_IN_SET. But she has performance problems, the correct thing would be to model the bank in another way and use a relationship table, as already suggested in Alfredo Silveira’s response and rray comment.

For the record, follow an example of gambiarra with the FIND_IN_SET:

SELECT tabela1.*
FROM tabela1
    INNER JOIN tabela2
    ON FIND_IN_SET(tabela2.id, tabela1.id_subfiltro) > 0