mysql trigger variables

Question

In MYSQL, how do you assign a field name fname from the table ftable to a variable within a trigger query?

I am aware of mysql global variables: @@
Local Variables? @

But is that even the right syntax?

Answer 1

You can just assign it from the field right in the select; it would get the last selected value if several rows are returned.

SELECT @tmp:=fvalue FROM ftable WHERE ...

A simple SQLfiddle here.