student表中有姓名字段name,并且存在name为“sun%er”的记录。下面选项中,可以匹配“sun%er”字段值的SQL语句是()。
A:SELECT * FROM student WHERE name LIKE sun%er;
选项:
A:SELECT * FROM student WHERE name LIKE ' %%%';
B:SELECT * FROM student WHERE name LIKE ' %\%%';
C:SELECT * FROM student WHERE name= ' sun%er';
发布时间:2024-04-23 16:01:26