查找student 表中所有电话号码(列名: telephone)的第一位为1,第四位为1到5的电话号码( )。
选项:
A:SELECT telephone FROM student WHERE telephone LIKE '1__[1-5]%*'(下划线2个);
B:SELECT telephone FROM student WHERE telephone LIKE '1_[1-5]%*'(下划线1个);
C:SELECT telephone FROM student WHERE telephone LIKE '1%[1-5]%*';
D:SELECT telephone FROM student WHERE telephone LIKE '1%%[1-5]%*'
发布时间:2024-04-20 22:37:39