date index question

2005-12-20 Thread Mattias Håkansson
Hello People, I have some indexing problem on using the fieldtype 'date' as restriction in a query. I use MySQL Server version: 4.0.20 The table I have consists of roughly over 200.000 rows about 37 fields and it looks sort of like this: mysql desc the_table;

Re: Calculate LONG/LAT from ZIP+4

2005-06-28 Thread Mattias Håkansson
This one goes for $169, and you get longitudes and latitudes. http://www.buyzips.com/platinum-expanded.htm Regards, Mattias Håkansson - Original Message - From: Jack Lauman [EMAIL PROTECTED] To: MySql mysql@lists.mysql.com Sent: Monday, June 27, 2005 2:29 AM Subject: Calculate LONG

Weird Query Result

2005-04-05 Thread Mattias Håkansson
these results. Anyone have a clue what is causing this? Thank you for your time, Mattias Håkansson

Re: Weird Query Result

2005-04-05 Thread Mattias Håkansson
Yes, It's pretty obvious now. Thank you all for the help. Mattias Håkansson - Original Message - From: Gabriel PREDA [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, April 05, 2005 12:15 PM Subject: Re: Weird Query Result Not weird at all... As you can see it returnet all