有一张Person表包含如下信息:
Id | Name | Address | Career |
1 | Bob | China Town | Chef |
2 | Carter | Oxford Street | Teacher |
3 | Anna | Fourteen Avenue | Dancer |
现要选取居住地址Address不以'C'或'O'开头的人员信息,下列MySQL查询语句正确的是:
Id | Name | Address | Career |
1 | Bob | China Town | Chef |
2 | Carter | Oxford Street | Teacher |
3 | Anna | Fourteen Avenue | Dancer |
现要选取居住地址Address不以'C'或'O'开头的人员信息,下列MySQL查询语句正确的是:
SELECT * FROM Person Address REGEXP '^[^CO]';
SELECT * FROM Person Address LIKE '[!CO]%';
SELECT * FROM Person Address LIKE '[^CO]%';
SELECT * FROM Person Address REGEXP '^[CO]';