Sort VARCHAR as INT in MySQL
Jun1
Sometimes we can user VARCHAR for integer values. But when we need sort them, we have got big problem. Because VARCHAR’s are string and it is sorting like a string.
Example:
1a 2a 3a 10b 20b 30b 15c 25c 35c (VARCHAR)
1a 10b 15c 2a 20b 25c 3a 30b 35c (Sorted)
We need
1a 2a 3a 10b 15c 20b 25c 30b 35c (Sorted integer)
We can do it with mysql CAST
SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED)
Reverse orderSELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED) DESCOther possible conversion types you may need are:
- BINARY[(N)]
- CHAR[(N)]
- DATE
- DATETIME
- DECIMAL[(M[,D])]
- SIGNED [INTEGER]
- TIME
- UNSIGNED [INTEGER]
Google Create New Programming Language : GO
Nov0
Google Engineers create new programming language “Go”. In first look it is look like C++ or Java. We will see, how it will be.
More details :
http://www.golang.me/google-launches-its-own-programming-language-go/
Facebook Acquires Friendfeed
Aug7
Facebook & FriendFeed
Facebook and FriendFeed share a common vision of giving people tools to share and connect with their friends,” FriendFeed co-founder Bret Taylor said in a release. “We can’t wait to join the team and bring many of the innovations we’ve developed at FriendFeed to Facebook’s 250 million users around the world.”
As an announcement of FriendFeed, they accepted Facebook’s offer. http://blog.friendfeed.com/2009/08/friendfeed-accepts-facebook-friend.html
TechCrunch, Mashable and cnet wrote this news. Here is the articles.
http://www.techcrunch.com/2009/08/10/facebook-acquires-friendfeed/
http://mashable.com/2009/08/10/facebook-acquires-friendfeed/
http://news.cnet.com/8301-13577_3-10306560-36.html
| Website: | facebook.com |
| Location: | Palo Alto, California, United States |
| Founded: | February 1, 2004 |
| Funding: | $716M |
| Website: | friendfeed.com |
| Location: | Mountain View, California, United States |
| Acquired: | August 10, 2009 by Facebook |
Free Online Virus Scanner
Jul2
I told i have got problems with “jl.chura.pl virus“. When i search about solving my virus problem, i found lots of online virus scanners on net. I want to share with you this web sites. No program or download need for this virus scanners.
My blog posts about jl.chura.pl virus;
Here is the full list of free online virus scanners:
Copyright Dispute for your Dedicated Server at GoDaddy
Jul2
4 days ago i get mail from GoDaddy.com Copyright Claims Dept. They told me “One of my site
has come to our attention that the website found on this server contains
material being displayed without the consent of the owner/copyright
holder.” That web site is forum and users posts items. But my server is suspended. I tried to re-open my server for 3 days. Now my server is up. I like GoDaddy.com’s support team, they are really fast and helpful. But Copyright Claims Dept. is very slow, i sent 5 mails in these 3 days and i didnt get any answer. My answer is come yesterday, after 3 days. They told me send mail in certain format, format is;
“I, John Doe, under penalty of perjury, will remove the offending content
at [insert full resolving URL] promptly after the reactivation of my
services.
John Doe
(Please accept the above as an electronic signature.) – I scan my signature and attached with mail.
Regards,
Copyright Department
GoDaddy.com
CopyrightClaims@GoDaddy.com”
I sent this kind of mail to CopyrightClaims@godaddy.com and they opened in 1 hour. I remove copyrighted data. I hope no ones server will no suspended. Dont forget if there is a problem with Copyright content in GoDaddy only CopyrightClaims@godaddy.com answers your mail and can help you.
Social
