As in my previous post, here's the modified version to list out friends with birthday in the month of May in Facebook.
SELECT name,uid,birthday_date FROM user WHERE uid IN (SELECT uid1 FROM friend WHERE uid2=me()) AND strpos(birthday_date,'05') = 0 |
You can change the month (highlighted in blue) to some other values.
No comments:
Post a Comment