Use wildcards to solve problems with data 1 and 11, 12/13/14

Update Fourxiaozhang Set president23_1 = ' 1 ' WHERE President23 like ' 1|% ';
Update Fourxiaozhang Set president23_1 = ' 1 ' WHERE President23 = ' 1 ';
Update Fourxiaozhang Set president23_2 = ' 1 ' WHERE President23 like '%[^1]2% ';
Update Fourxiaozhang Set president23_3 = ' 1 ' WHERE President23 like '%[^1]3% ';
Update Fourxiaozhang Set president23_4 = ' 1 ' WHERE President23 like '%[^1]4% ';
Update Fourxiaozhang Set president23_5 = ' 1 ' WHERE President23 like '%[^1]5% ';
Update Fourxiaozhang Set president23_6 = ' 1 ' WHERE President23 like '%[^1]6% ';
Update Fourxiaozhang Set president23_7 = ' 1 ' WHERE President23 like '%7% ';
Update Fourxiaozhang Set president23_8 = ' 1 ' WHERE President23 like '%8% ';
Update Fourxiaozhang Set president23_9 = ' 1 ' WHERE President23 like '%9% ';
Update Fourxiaozhang Set president23_10 = ' 1 ' WHERE President23 like '%10% ';
Update Fourxiaozhang Set president23_11 = ' 1 ' WHERE President23 like '%11% ';
Update Fourxiaozhang Set President23_12 = ' 1 ' WHERE President23 like '%12% ';
Update Fourxiaozhang set president23_13= ' 1 ' WHERE President23 like '%13% ';

Use wildcards to solve problems with data 1 and 11, 12/13/14