单项选择题

A.Select *from publishers where pub_name=’N’
B.Select *from publishers where pub_name like ’N%’
C.Select *from publishers where pub_name like ’N’
D.Select *from publishers where pub_name like ’P[^N]%’