今天在网上看到一女程序员的征婚信息：
SELECT * FROM 男人们
WHERE (未婚=true OR 离异=true)
AND 同性恋=false
AND 穷光蛋=false
AND 有房=true
AND 有车=true
AND 条件 IN (’细心’,'温柔’,'体贴’,'贤惠’,'会做家务,会做饭,会逛街买东西,会浪漫,活泼,可爱,帅气,绅士,大度,气质,智慧’,'最好还能带孩子 ‘)
非常佩服这位女程序员的SQL功底，我也学着写一段：
SELECT id, name, QQ, msn, mobile, photos,
(IF(孝顺,5,0)+IF(温柔,5,0)+IF(体贴,3,0)+IF(贤惠,3,0)+IF(可爱,2,0)+IF(气质,2,0)+IF(上海人,1,0)+(birth-1980)+(165-height)+(65-weight)) AS score
FROM women
WHERE single=true
AND divorce=false
AND homosexuality=false
AND education<=’master’
AND age<=28 AND age>=20
AND height<=165
AND weight<=65
AND boyfriends=0
AND live=’Shanghai’
ORDER BY score DESC
希望结果不会是0 row(s) affected