Use result of an SQL query as attribute to another query.(MYSQL)

Question

I have the following structure:

tabela (Grupo):
-cd_grupo
-nm_grupo
-ds_filtros -> Aqui armazeno parte do comando SQL utilizado como filtro , para posteriormente atualizar.

I store the following information.

cd_grupo  |   nm_ grupo  |   ds_filtro
   1      |    grupo1    | AND (uf = 'PR') AND (genero = 'F')
   2      |    grupo2    | AND (nasc >= '1990-02-20')

there is another link table, where bind employees according to the group filter.

cd_grupo  |   cd_funcionario
   1      |        14
   1      |        19
   1      |        35

my doubt is necessary to update the link table when changes the status of the employee and when it is inserted working new.

This way down I know it doesn’t work but the idea would be this:

SELECT cd_funcionario FROM funcionario WHERE (SELECT ds_filtros FROM grupo)

That would bring the filters "AND (Uf = 'PR') AND (genero = 'F')" and add after the clause WHERE

Have some alternative to store filters or if this way you have to search for all filters in the group table and apply them in another SQL command be it REPLACE, UPDATE or INSERT ?

I am using PHP with Mysql.

Answer 1

I have an example that I’ve done a do, so yours will stay but or so in my bank has then he shows

 <?php
    $host ="localhost";
    $usu="root";
    $senha="";
    $bd="ts";
    $link = mysqli_connect($host, $usu, $senha, $bd);
        $sql="SELECT `numero` FROM `ts` WHERE id=1";
        $execut=mysqli_query($link,$sql);
        while($row= MYSQLI_FETCH_ARRAY($execut)){
                $filtro=$row['numero'];
        }
        $sql="SELECT `numero` FROM `ts` WHERE $filtro";
        $execut=mysqli_query($link,$sql);
        while($row= MYSQLI_FETCH_ARRAY($execut)){
                $filtro=$row['numero'];
        }
        echo $filtro;
    ?>