查找 student表中所有电话号码(列名:telephone)的第一位为8或6,第

9 查阅
查找 student表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码()

SELECT telephone FROM student WHERE telephone LIKE '[8,6]%0*'

SELECT telephone FROM student WHERE telephone LIKE '(8,6)*0%'

SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0%'

SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0*'

参考答案:

C

SQL试