469,931 Members | 1,799 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,931 developers. It's quick & easy.

select week in date

hii

i have face a problem in mysql .i have a table register and have a field

uid,name,date

so i have want to select uid by weekly,means whose registration in current week
so plz help me and find the solution

thanks
Dec 18 '06 #1
3 4987
ronverdonk
4,258 Expert 4TB
Depending on what day your week (Sunday or Monday) starts this could do it:
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM table 
  2. WHERE DATE_FORMAT(date, "%u") = DATE_FORMAT(curdate(), "%u");
Ronald :cool:
Dec 18 '06 #2
tnxx for this soln

one question or more

mysql support foriegn key or not, if not then what is the alternative.
and support constraiont or not plz reply me

bye
Dec 21 '06 #3
ronverdonk
4,258 Expert 4TB
You have already started a new thread in this forum with that last question. Don't overdo it!

Ronald :cool:
Dec 21 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by bad | last post: by
2 posts views Thread by androtech | last post: by
2 posts views Thread by hikums | last post: by
reply views Thread by Lee Harr | last post: by
6 posts views Thread by aarklon | last post: by
1 post views Thread by kropinek | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.