MySql insert into ... select

select @f := ....., SUBSTRING_INDEX(@f, ',', 1) as f1,reverse(SUBSTRING_INDEX(reverse(@f), ',', 1)) as f2

f1 in f2 moram insertirat v eno tabelo, torej insert into ... select
se ne da ker ga moti

@f :=

niti ne sprejme sql-a z variablo v view

Kakšen predlog ?
Nekako sumim da tudi cretae table as select ... ne bo delalo, vsekor pa mi je to najmanj všeč.