Re: Date format question

Assign all dates to have a day of 01 Store in a date field, use DATE_FORMAT to just extract the MM and . As you don't have the real day information it doesn't matter what day is used, so long as it present in all months. Hope this helps Robert Gehrig Webmaster at www.gdbarri.com e-mail

Missing information Search

. Thanks Robert Gehrig Webmaster at www.gdbarri.com e-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Help

I have a table like so: ID int val1int val2int I can have multiple records where id is the same. e.g: ID val1val2 1 1 2 1 1 1 2 2 2 2 1 1 2 2 2 I need to find which id has the most records. Thanks Robert Gehrig

Re: Query Help

Thanks that got it. Robert Gehrig Webmaster at www.gdbarri.com e-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Problem

for the same Id (the result in this case would be 34) How do I do this with a SQL query Thanks Robert Gehrig Webmaster at www.gdbarri.com e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com