按照关键查询时，多关键词查询正确的是
A: “Select * from news where like ‘%”.$wd.”%’”
B: “Select * from news where title regexp ‘%”.$wd.”%’”
C: “Select * from news where title like ‘%”.$wd.”%’”
D: “Select * from news where title regexp ( ‘%”.$wd.”%’)”
A: “Select * from news where like ‘%”.$wd.”%’”
B: “Select * from news where title regexp ‘%”.$wd.”%’”
C: “Select * from news where title like ‘%”.$wd.”%’”
D: “Select * from news where title regexp ( ‘%”.$wd.”%’)”
举一反三
- 查询姓“李”的学生的所有信息 A: select * from student where sname like ‘#李%’ B: select * from student where sname like ‘%李#’ C: select * from student where sname like “%李%” D: select * from student where sname like ‘%李%
- 下列语句（）能够查询所有英语类课程的信息。 A: SELECT * FROM Course WHERE cname LIKE ‘%英语’ B: SELECT * FROM Course WHERE cname LIKE ‘%英语%’ C: SELECT * FROM Course WHERE cname LIKE ‘_英语_’ D: SELECT * FROM Course WHERE cname LIKE ‘*英语*’
- 查询“图书”表中书名含有“计算机”的图书信息，正确的选项是______。 A: select * from book where bname like ‘_计算机_’ B: select * from book where bname like ‘_计算机%’ C: select * from book where bname like ‘%计算机_’ D: select * from book where bname like ‘%计算机%’
- 设ABC表的A列存储电话号码信息，查询不是以7开头的所有电话号码的查询语句是（ ）。 A: SELECT A FROM ABC WHERE A IS NOT ‘%7’ B: SELECT A FROM ABC WHERE A LIKE ‘%7%’ C: SELECT A FROM ABC WHERE A NOT LIKE ‘7%’ D: SELECT A FROM ABC WHERE A LIKE ‘[1-6]%’
- 要查询Goods表中商品中含有“电冰箱”的商品情况，可用（ ） A: SELECT * FROM Goods WHERE g_Name LIKE '电冰箱%' B: SELECT * FROM Goods WHERE g_Name LIKE '电冰箱_' C: SELECT * FROM Goods WHERE g_Name LIKE '%电冰箱%' D: SELECT * FROM Goods WHERE g_Name='电冰箱'