RE: [MLUG - DISCUSSION] random db results?

["Ross, Matt" <EMAIL:PROTECTED>]

Another thought.  You could match by soundex on a text field, using letters
randomly thrown together.  Not perfect, but it gets some randomness.

--------------------------------------------
                Matthew W. Ross
                 DED MIS Temp
                Phone: 522-6284
        E-Mail: EMAIL:PROTECTED
               Network: DD05908
         Graduate of LU, May 11, 2002
--------------------------------------------
Anonymity is the key problem in today`s society.
-Anonymous
--------------------------------------------


> -----Original Message-----
> From: Michael [mailto:EMAIL:PROTECTED]
> Sent: Wednesday, July 03, 2002 7:21 AM
> To: EMAIL:PROTECTED
> Subject: [MLUG - DISCUSSION] random db results?
> 
> 
> Does anyone know how to ask for random results from a db? 
> Something like:
> 
> 'SELECT id FROM files WHERE view = 0 GROUP BY random LIMIT 25'
> 
> 
> The girl who stoops to conquer usually wears a low-cut dress.
> 
> ;):):-):):-):):-)8')
> Michael McGlothlin <EMAIL:PROTECTED>
> http://kavlon.org/projects/
> 
> --
> To unsubscribe, go to http://mlug.missouri.edu/members/edit.php
> 
> Archives are available at http://mlug.missouri.edu/list-archives/
> 
--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/