Get multiple match value REGEXP [Mysql]

i have some issue about get value from regexp. i want get multiple match value from example this string

"'#{farmingmethod}' != '2' || '#{farmingmethod3}'" that begin with "#{".

i tried this query :

SELECT REGEXP_SUBSTR("'#{farmingmethod}' != '2' || '#{farmingmethod3}'", '[#{]([^{]+)[}]');

but as i know from mysql documentation REGEXP_SUBSTR only return one value "farmingmethod".

Expected return "farmingmethod","farmingmethod3" or multiple rows any solution for that?