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:

(more…)

Hug your computer

I hugged my computer today. It’s been almost a year without a computer in my house that I could call my own. My computer has returned home from a 10 month stint at work, and it’s good to have it home. Life just keeps getting better 🙂 Maybe I’ll do some coding like I’ve been meaning to since about November 2001…. 🙂

Where am I?

I been working. 😛 Trying to fix this damned graph/chart making actionscript in flash. I finally got it working so yay! Now I get to take xml data from a .NET service and put it into this flash… should be easy. After that I get to make it into a component. Exciting? Yes and no. Turning it into a component will be a task and a half of full cream coffee. Anyway, better get back to work. Mental note: blog more often.

Hamilton Hooooooo!

Yup. A client of ours has flown Mufasa and myself to Hamilton in the Waikato. For you overseas ppl, Hamilton is a 1.5 hour drive south of Auckland. We’re in a building that I think is right next to the Waikato River. Well, I think it’s the Waikato… there’s no signs and I don’t have enough guts to ask anyone just yet. Mind you, the coffee was good… better than the swill on the Air New Zealand flight in. Plans are to go see Hillary, my friend in Auckland tonight, maybe even crash out at her place. We’ll see. Better dash, pizza is here!

Mmm… winamp -> web

Yeah, BlogAmp used to be good. but with that kind of product you’re bound to be one up’d by someone. And hey, I’m not complaining! I have it set up to tell a php script I wrote what track i’m listening to, or last listened to, and it’s saved on the server, and then put on the sidebar there for your curiosity.