Latest News

Putting the "squeal" back into SQL

9th September 2005

For my long-term gaming project, State Secrets, I had to write this gem of SQL code:

SELECT c.*,length(session_id) as online FROM characters as c LEFT JOIN users as u ON u.current_char=c.id LEFT JOIN sessions as s USING (username) WHERE u.username != "admin" ORDER BY c.savvy DESC

Even now, that double join makes my eyes bleed.

0 Comments | Add comment | Tags: computers • programming • sql

Current Status

New a pseudocertainty episode? Yes. http://bit.ly/93m5YR

Posted: Thu Jan 28 00:49:06 +0000 2010

--Via identi.ca

About this blog

The taskboy blog is a exploration of computer technology by Joe Johnston. Topics of posts include practical examples Perl, PHP, Python and Java as well as book reviews, industry insights and miscellaneous good stuff.