472,121 Members | 1,443 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,121 software developers and data experts.

select week in date


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


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

Dec 18 '06 #1
3 5080
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

Dec 21 '06 #3
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.