Page 1 of 1

How to implement select to save the value, not the ID

Posted: Wed Apr 06, 2022 5:35 pm
by hujunhong
If my product_bank select value is
0|AAA|1|BBB|2|CCC|3|DDD|
I want the database to store AAA, BBB, CCC
not is 0, 1, 2

How to use functions

Re: How to implement select to save the value, not the ID

Posted: Wed Apr 06, 2022 5:38 pm
by kev1n
Change it to

AAA|AAA|BBB|BBB|CCC|CCC|DDD|DDD

Re: How to implement slect to save the value, not the ID

Posted: Thu Apr 07, 2022 5:38 pm
by hujunhong
kev1n wrote: Wed Apr 06, 2022 5:38 pm Change it to

AAA|AAA|BBB|BBB|CCC|CCC|DDD|DDD
OK thanks