Monkeyjay made this one up:
Q) What do hobbits use to manipulate images?
A) Frodoshop.
Yes, extremely lame joke. Smileychris will be proud 🙂
Category Archives: Work
Baby’s First Kernel Re-compile
Yup, today at work I installed Debian Linux 3.0 on a box we dubbed Radar, after the character from M*A*S*H, to go along with our test server, Hawkeye. I think Klinger is the next one we’ll put together. So yeah, I did my first kernel re-compile. W00t 😉
New Job
Tomorrow morning I start work at Dev-Zone.org. W00t! Just a friendly hi to all my new friends at dev-zone, especially Daniel and Don in my department. I’ve been looking forward to starting for just over 3 weeks now, and I’m glad to be. New jobs are always exciting!
I’m well again
Just to let you know, i’m back at work.
Mother of All SQL statements
SELECT ``. * , `regions`.`regionname` ,
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
' runner '
) AS relevance
FROM `regions`
INNER JOIN `` ON ( `regions`.`id` = ``.`region_id` )
WHERE (
(
``.businessflag = 0 AND ``.name_last
LIKE 'runner'
)
) OR (
(
``.businessflag = 1
) AND
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
'runner'
) > 0
)
HAVING relevance > 0
ORDER BY relevance DESC
OK, maybe not the mother of all SQL statements, but maybe the PHP will convince you otherwise:
