Selecting Random entries from MySQL

Discussion in 'PHP' started by warsome, Apr 17, 2008.

0
  1. #1
    Alright, so, I am creating (Upgrading, actually,) my arcade script. I have a catagories system, but it still displays WAY too much on the front page.
    I have a Table, called games. The Rows are incategory, and name.

    What I want it to do is select a random game that has:
    incategory 1, and to choose a random name from the list.

    Is this possible?
     
    warsome, Apr 17, 2008 IP
  2. adwads.com

    adwads.com Peon

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Select a random row with MySQL:

    SELECT column FROM table
    ORDER BY RAND()
    LIMIT 1

    Select a random row with PostgreSQL:

    SELECT column FROM table
    ORDER BY RANDOM()
    LIMIT 1

    Select a random row with Microsoft SQL Server:

    SELECT TOP 1 column FROM table
    ORDER BY NEWID()

    Select a random row with IBM DB2

    SELECT column, RAND() as IDX
    FROM table
    ORDER BY IDX FETCH FIRST 1 ROWS ONLY

    Thanks Tim
    Select a random record with Oracle:

    SELECT column FROM
    ( SELECT column FROM table
    ORDER BY dbms_random.value )
    WHERE rownum = 1


    google is your friend ;)
     
    adwads.com, Apr 17, 2008 IP
  3. thomas2003

    thomas2003 Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You can call a random item using mysql rand().

    example using mysql:

    select * from table_name ORDER BY rand() LIMIT 10

    just google rand() for more info
     
    thomas2003, Apr 17, 2008 IP