[eluser]Developer13[/eluser]
[quote author="richthegeek" date="1222308113"]I think this might be too complicated to do it with pure SQL, but I'm sure some SQL guru will disagree with me here...[/quote]
Kind of OT, so sue me... :-)
Okay... at first all I read on your reply was the "I think this might be too complicated to do it with pure SQL..." and didn't see the "but I'm sure some SQL guru will disagree with me here" part. Not that I'm a SQL guru by any means, but so many applications truly under-utilize the potential of the internal database processing power. So many things can be achieved in much simpler ways by writing creative queries, using stored procedures, etc etc instead of writing a mass of code that will most likely take longer to execute than MySQL (or others) could do it natively.
With each new application I write, I try to find a couple of new things I can use the database server for to offload my code. So much of it can simply be done with the way queries are structured - SQL is a very powerful language.
