Here is a small #MySQL tip: Say you want to order your query results alphabetically, but keep the empty fields last, what do you do? If you do
SELECT string FROM table ORDER BY string;
You will get ‘ ‘, ‘ ‘, ’1′, ’2′, ’3′, ‘A’, ‘B’, ‘C’
But if you do
SELECT string FROM table ORDER BY ! ASCII(string), string;
You will get ’1′, ’2′, ’3′, ‘A’, ‘B’, ‘C’, ‘ ‘, ‘ ‘.
Tip found at www.wonkabar.org
Google+: View post on Google+
Related
There are various solutions (with varying paying options) if you want to monitor your #social network efforts but there is also an open-source solution. +ThinkUp, led by +Gina Trapani, is a web application that can provide you statistics on your #Facebook , #Twitter and #Google + accounts and pages. Included…
// WP Security Scan is a set of tools for adding some basic #security on your #WordPress installation. It includes: - A series of tests like if you have the latest version, if you're not telling the world your version of WordPress, .htaccess protection, etc (see screenshot) - Information on your PHP/MySQL…