I am trying to use a variable from a column in the first select to populate the against clause in the second query.

select m.menuitem, m.menuname,m.menutype, @a := m.menusearch, 
(select count(*) as total from nametable where match(name) against (@a)  )  as total from menu m
Just wondering if this is possible, and whether my code is anywhere near close?