You can't at this point. But anyway, it is usually better to make your application do the work than your database. MySQL doesn't process functions faster than you would with arrays (which is what it would have to do ) and it's better to take as much load off from your database. Even if you could do it, it wouldn't be faster and it would take a toll on your DB, making other simultaneous queries slower, and your whole project would be slower. Whenever possible, have your application process functions for your database. A database should concentrate on queryiong the data and your program should perform as many functions as possible.
On Wednesday 24 October 2001 07:14 am, Christian Andersson wrote: > Hi there, I have a small question for you all (and yes I have searched the > documents but not be able to found what I want) > > Lets say that I have a table with these values 1, 5 and 7 > is it possible to create an sql query that will "loop" through these values > a certain amount of time for example if i wanted 8 rows I would get 1, 5, > 7, 1, 5, 7, 1, 5 as output.. > > I'm currently doing this looping in my application but it would speed > things up if mysql could do this for me.. > > since I could then do some joins and retrieve values from other tables > faster. > > /Christian Andersson > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
