MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.30


CREATE TABLE configure_country (id int, `name` VARCHAR(32));
insert into configure_country values (0, 'VAL 0');
insert into configure_country values (1, 'VAL 1');
insert into configure_country values (2, 'VAL 2');
insert into configure_country values (3, 'VAL 3');
insert into configure_country values (4, 'VAL 4');
insert into configure_country values (5, 'VAL 5');
insert into configure_country values (6, 'VAL 6');
insert into configure_country values (7, 'VAL 7');
insert into configure_country values (8, 'VAL 8');

CREATE TABLE filters_portfoliofilter (id int, portfolio_id int, `values` VARCHAR(32));
insert into filters_portfoliofilter values (1, 1, '3, 4, 7');
insert into filters_portfoliofilter values (1, 2, '1, 4, 6');
insert into filters_portfoliofilter values (1, 3, '3, 8, 0');
insert into filters_portfoliofilter values (2, 4, '3, 8, 0');
SET @portfolio_id = 1;
SELECT filters_portfoliofilter.values
FROM filters_portfoliofilter
WHERE id = 1
AND portfolio_id = @portfolio_id;


values


3, 4, 7


SET @portfolio_id = 2;
SELECT configure_country.name
FROM configure_country
CROSS JOIN ( SELECT filters_portfoliofilter.values
  FROM filters_portfoliofilter
  WHERE id = 1
  AND portfolio_id = @portfolio_id) AS fp
WHERE FIND_IN_SET(configure_country.id, REPLACE(fp.values,' ','')) >0;


name


VAL 1

VAL 4

VAL 6