Snipplr

(MySQL) Find off days in a date range using mysql - aamirrajpoot

Thu, 14 Jul 2011 01:12:30 UTC

A function to get off days inside mySQL

(MySQL) Order By rand() Reduce Time - aamirrajpoot

Mon, 10 Jan 2011 23:25:41 UTC

A guy asked me to reduce the query execution time. He is getting 10 results but the query had joins which makes it time consuming.

(MySQL) Alpha Numeric Sorting in MySQL - aamirrajpoot

Fri, 01 Oct 2010 22:53:53 UTC

Okay, If it is required to sort columns like this 1A 1a 10A 9B 21C 1C 1D And Our desired Result is 1A 1C 1D 1a 9B 10A 21C We can use casting, but casting will not sort 1A, 1B,1C properly. To overcome this issue we are first converting this column to binary and sorting the binary combined with tbl_column. hehe,,, after doing some headbanging just did it with casting too... and using same logic... damn why I didnt thought of that.