Combine 3 columns and add them into another column

[Kalpana Kanthasamy]

Hi

Just wondering if a trigger is able to do the following,

I have three columns, that reprsent, {prefix, autonumber, suffix}.

Both the prefix and suffix will be generated by php function, mysql will generate the autonumber column, I want all these 3 columns data to appear in another column in the mysql table

For example, say

prefix = 08
autonumber =001
suffix = A

I want the other column, let's name it as PAS, to have 08001A

Could anyone help me, I am new to the trigger thing