单选题

表X(id,name)，表Y(id,identity_card)通过id关...

Question

表X(id,name)，表Y(id,identity_card)通过id关联，如果需要查找身份证号identity_card以“110100”开头的所有人的信息，下列效率最优的MySQL语句是()

A. select * from X inner join Y on X.id = Y.id where identity_card &lt=&quot110100&quot and identity_card &gt &quot110100&quot

B. select * from X inner join Y on X.id = Y.id where identity_card like &quot110100%&quot

C. select X.id,X.name,Y.identity_card from X,Y where X.id = Y.id and identity_card &lt=&quot110100&quot and identity_card &gt &quot110100&quot

D. select X.id,X.name,Y.identity_card from X,Y where X.id = Y.id and identity_card like &quot110100%&quot