要找出所有名字第二个字母为“a”的导演的电影信息 SQL语句为——
已帮助 人
要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为——
A．SELECT * FROM Movie WHERE director LIKE ‘_a_’;
B．SELECT * FROM Movie WHERE director LIKE ‘%a%’;
C．SELECT * FROM Movie WHERE director LIKE ‘%a_’;
D．SELECT * FROM Movie WHERE director LIKE ‘_a%’;
回答
共1条回复-
SELECT * FROM Movie WHERE director LIKE ‘_a%’;