Professional Web Applications Themes

ranking in mysql query - MySQL

Hi all, just wondering if its possible to do a ranking with an update query ? all suggestions are appreciated...

Sponsored Links
  1. #1

    Default ranking in mysql query

    Hi all,

    just wondering if its possible to do a ranking with an update query ?

    all suggestions are appreciated


    Sponsored Links
    toffee Guest

  2. #2

    Default Re: ranking in mysql query

    can you elaborate?

    toffee wrote:
    > Hi all,
    >
    > just wondering if its possible to do a ranking with an update query ?
    >
    > all suggestions are appreciated
    strawberry Guest

  3. #3

    Default Re: ranking in mysql query

    toffee wrote:
    > just wondering if its possible to do a ranking with an update query ?
    I'm trying to guess what you mean, does this come close?

    SET i = 0;
    UPDATE tablename
    SET rank_column = (i:=i+1)
    ORDER BY order_column;

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Is this a MySQL Query bug?
    By Carl Anatorian in forum MySQL
    Replies: 4
    Last Post: June 13th, 07:29 AM
  2. Replies: 0
    Last Post: November 4th, 05:38 PM
  3. Query log for mySQL?
    By Kevin Thorpe in forum PHP Development
    Replies: 3
    Last Post: November 27th, 05:10 PM
  4. mysql/php query
    By aaron in forum PHP Development
    Replies: 13
    Last Post: November 17th, 11:18 PM
  5. ASP/SQL Ranking Query
    By Bob Barrows in forum ASP Database
    Replies: 3
    Last Post: August 8th, 10:59 AM

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