Sort VARCHAR as INT in MySQL

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 order
SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED) DESC
Other possible conversion types you may need are:
  • BINARY[(N)]
  • CHAR[(N)]
  • DATE
  • DATETIME
  • DECIMAL[(M[,D])]
  • SIGNED [INTEGER]
  • TIME
  • UNSIGNED [INTEGER]
You can find more about CAST -> MySQL docs here.

Google Create New Programming Language : GO

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

Facebook & FriendFeed

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

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:

  1. Kaspersky Virus Scanner
  2. Symantec Security
  3. Mcafee Scan
  4. Bit Defender Scan
  5. One Care Live
  6. Ca Security Advisor Virus Info Scan
  7. Ewido Online Scan
  8. Panda Security Active Scan

Copyright Dispute for your Dedicated Server at GoDaddy

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.

Oyun