Professional Web Applications Themes

Newbie needs help with query - MySQL

Hi, Is there a query which will select x random unique records out of all records and sort them randomly, but if all records is smaller than x then it chooses all the records and sorts them randomly. e.g choose 3 random unique records out of all records (20) and sort them randomly (5,1,14) , but if there are only 2 records it chooses the 2 records and sorts them randomly (2,1). Thank you in advance, Raj (Newbie)...

  1. #1

    Default Newbie needs help with query

    Hi,

    Is there a query which will select x random unique records out of all records
    and sort them randomly, but if all records is smaller than x then it chooses
    all the records and sorts them randomly.

    e.g choose 3 random unique records out of all records (20) and sort them
    randomly (5,1,14) , but if there are only 2 records it chooses the 2 records
    and sorts them randomly (2,1).

    Thank you in advance,

    Raj (Newbie)

    raj Guest

  2. #2

    Default Re: Newbie needs help with query

    raj <com> wrote:
     

    Hmmmz, why didn't my reply show up? Retry:
    Uniqueness depends on the table.

    SELECT * FROM tablename ORDER BY RAND() LIMIT max_number

    --
    Rik Wasmus
    Posted on Usenet, not any forum you might see this in.
    Ask Smart Questions: http://tinyurl.com/anel
    Rik Guest

  3. #3

    Default Re: Newbie needs help with query

    Thanks for the answer Rik.

    Sorry about the crosspost. Won't happen again. Will read up on crosspost on
    google now.

    Raj

    On Tue, 6 Mar 2007 08:31:17 +0000, Rik wrote
    (in article <op.tordyf0jqnv3q9misant>):
     
    >
    > Hmmmz, why didn't my reply show up? Retry:
    > Uniqueness depends on the table.
    >
    > SELECT * FROM tablename ORDER BY RAND() LIMIT max_number
    >
    >[/ref]


    raj Guest

Similar Threads

  1. datagrid query-newbie
    By vijaya in forum ASP.NET Building Controls
    Replies: 0
    Last Post: December 3rd, 11:22 AM
  2. A newBie Query
    By Naren in forum PERL Miscellaneous
    Replies: 3
    Last Post: September 18th, 08:50 AM
  3. [newbie] Array and query
    By Nexus in forum PHP Development
    Replies: 4
    Last Post: September 16th, 08:13 AM
  4. .net newbie query
    By Kaushik in forum ASP.NET General
    Replies: 2
    Last Post: August 22nd, 11:50 AM
  5. Help ASP newbie with webhits query
    By Colin Bruce in forum ASP
    Replies: 1
    Last Post: August 6th, 10:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139