SELECT cuscode FROM check_stock_delete
group by cuscode
order by cuscode
Array
(
[0] => Array
(
[0] => 27120051
[cuscode] => 27120051
)
[1] => Array
(
[0] => 30000076
[cuscode] => 30000076
)
[2] => Array
(
[0] => 30000093
[cuscode] => 30000093
)
[3] => Array
(
[0] => 30000096
[cuscode] => 30000096
)
[4] => Array
(
[0] => 30110015
[cuscode] => 30110015
)
[5] => Array
(
[0] => 31110011
[cuscode] => 31110011
)
[6] => Array
(
[0] => 43000030
[cuscode] => 43000030
)
)
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '27120051'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '30000076'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '30000093'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '30000096'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '30110015'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '31110011'
UPDATE c_customer set CUS_CF3='' where CUS_CODE = '43000030'