Re: Indexed Query examining too many rows!

2012-02-12 Thread Peter Brawley
On 2/12/2012 4:40 PM, Reindl Harald wrote: Am 12.02.2012 23:25, schrieb Cabbar Duzayak: Hi All, I have a table with a btree index on its searchKey column, and when I send a simple query on this table: explain select * from DataIndex where (searchKey like 'A%') order by searchKey limit 10 rows

Re: Indexed Query examining too many rows!

2012-02-12 Thread Reindl Harald
Am 12.02.2012 23:25, schrieb Cabbar Duzayak: > Hi All, > > I have a table with a btree index on its searchKey column, and when I > send a simple query on this table: > > explain select * from DataIndex where (searchKey like 'A%') order by > searchKey limit 10 > > rows is returning 59548 and it

Re: Formatting Numbers with commas

2012-02-12 Thread Reindl Harald
Am 12.02.2012 16:59, schrieb Mike Blezien: > Hello, > > Is there a function to automatically format long numercial values before it's > entered into the table, i.e I have a > value like 159600 and would be entered as 159,600 or 78450 would be entered > 78,450 etc., ? you do not really want to d

Re: Formatting Numbers with commas

2012-02-12 Thread Mike Blezien
Thank you Simon exactly what I was looking for. Appreciate the assistance. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Custom Programming & Web Hosting Services -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - Original Messa

RE: Formatting Numbers with commas

2012-02-12 Thread Simon Griffiths
Please see http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format Regards, Simon Griffiths -Original Message- From: Mike Blezien [mailto:mick...@frontiernet.net] Sent: 12 February 2012 16:00 To: MySQL List Subject: Formatting Numbers with commas Hello, Is there