例如,我有下表:
Id | Name | Color |
---|---|---|
1 | FirstCar | White |
2 | SecondCar | Yellow |
3 | ThirdCar | Red |
4 | FourthCar | White |
5 | FifthCar | Green |
6 | SixthCar | Blue |
我需要实现的是:将字符串"\u 123"附加到所有行的字段"Name",其中"Name"是"SecondCar"、"FourthCar"或"SixthCar",结果如下:
Id | Name | Color |
---|---|---|
1 | FirstCar | White |
2 | SecondCar_123 | Yellow |
3 | ThirdCar | Red |
4 | FourthCar_123 | White |
5 | FifthCar | Green |
6 | SixthCar_123 | Blue |
我该怎么做?