手机或者邮箱登陆 mysql查询语句

现在很多登陆都是手机和邮箱混合登陆，mysql的查询语句现在想到的有两种。

其一是使用UNION：

SELECT *
FROM enterprisemember 
WHERE enterprisemember.MobilePhone = #{mobilephone}
AND
enterprisemember.memberPassword = #{memberpassword}
UNION
SELECT *
FROM enterprisemember
WHERE enterprisemember.mailbox = #{mailbox}
AND
enterprisemember.memberPassword = #{memberpassword}

其二是使用OR：

SELECT * 

FROM enterprisemember 

WHERE (MobilePhone = #{mobile} OR mailbox = {mailbox} )

and enterprisemember.memberPassword = #{memberpassword}