ENUM value from VIRTUAL COLUMN from another table

[cikguhelmi]

i need some help

i create virtual column in table "DATA PELAJAR" .i want to used it in another table as ENUM but it not working.. why?

[Marc_Dillon]

How is it not working?

[cikguhelmi]

i cannot select item from dropdown
https://drive.google.com/file/d/1IdiVZixv7oZwjWoiNtU9Fb0YVndRXOE5/view?usp=sharing

[Marc_Dillon · Accepted solution]

I'm not sure why, but it seems to be related to the trailing space you have on all of the values. Try removing that trailing space from every value in your switch expression.

[cikguhelmi]

😂yes you right....lol I intentionally added spaces after each letter for a specific purpose, which is to concatenate the resulting string with another column. I've been stuck on it for an hour. Thanks @Marc_Dillon