oracle 精確查詢和模糊查詢

精確查詢：

SELECT 

d.ACCOUNT_ as ACCOUNT_,

 

t.ID_,t.NAME_,t.PROFILE_,t.STATUS_,t.GENDER_,t.EMAIL_,t.ADDRESS_,t.MOBILE_,t.QQ_,t.WC_ACCOUNT_,t.PHOTO_,t.POSITIONS_,t.GROUP_ID_,t.CREATE_TIME_,t.UPDATE_TIME_,t.ORGID

      

FROM IBPS_PARTY_EMPLOYEE t

LEFT JOIN Ibps_Party_User d ON  t.ID_ =d.ID_

        

WHERE GENDER_ = 'male'

 

 

ORDER BY ID_ DESC

模糊查詢：

SELECT 

d.ACCOUNT_ as ACCOUNT_,

 

t.ID_,t.NAME_,t.PROFILE_,t.STATUS_,t.GENDER_,t.EMAIL_,t.ADDRESS_,t.MOBILE_,t.QQ_,t.WC_ACCOUNT_,t.PHOTO_,t.POSITIONS_,t.GROUP_ID_,t.CREATE_TIME_,t.UPDATE_TIME_,t.ORGID

      

FROM IBPS_PARTY_EMPLOYEE t

LEFT JOIN Ibps_Party_User d ON  t.ID_ =d.ID_

        

WHERE GENDER_ like  '%male%'

 

 

ORDER BY ID_ DESC