select week in date

[sandeepsandeep]

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

[ronverdonk]

Depending on what day your week (Sunday or Monday) starts this could do it:

SELECT * FROM table 
WHERE DATE_FORMAT(date, "%u") = DATE_FORMAT(curdate(), "%u");

Ronald :cool:

[sandeepsandeep]

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

[ronverdonk]

You have already started a new thread in this forum with that last question. Don't overdo it!

Ronald :cool: