Professional Web Applications Themes

ORDER BY with special order scheme? - MySQL

Is it possible to order the result by a given list? E.g. I have a "type" column and I want to return first the records with type 5, then with type 9, then with type 2 etc. -- Frank Buss, de http://www.frank-buss.de, http://www.it4-systems.de...

  1. #1

    Default ORDER BY with special order scheme?

    Is it possible to order the result by a given list? E.g. I have a "type"
    column and I want to return first the records with type 5, then with type
    9, then with type 2 etc.

    --
    Frank Buss, de
    http://www.frank-buss.de, http://www.it4-systems.de
    Frank Guest

  2. #2

    Default Re: ORDER BY with special order scheme?

    On 27 Jul, 08:21, Frank Buss <de> wrote: 

    see FIELD

    strawberry Guest

  3. #3

    Default Re: ORDER BY with special order scheme?

    strawberry wrote:
     

    Thanks, this works. Now I have the problem that the elements which are not
    in the FIELD array are showed first, e.g. select type from foo order by
    field(type, 99, 1, 88)

    0
    2
    99
    99
    99
    1
    1
    88

    Is it possible that all the elements which are not in the field array are
    ordered at the end of the other rows?

    --
    Frank Buss, de
    http://www.frank-buss.de, http://www.it4-systems.de
    Frank Guest

Similar Threads

  1. Tab Order always greyed out, need to redefine order but can't
    By Dominic_De_Lello@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 5
    Last Post: July 14th, 05:06 AM
  2. how to order, then limit, then order?
    By dankelley in forum MySQL
    Replies: 2
    Last Post: July 22nd, 11:27 AM
  3. Replies: 2
    Last Post: January 18th, 02:07 PM
  4. Updating records in order (into an order)
    By A Ratcliffe in forum ASP Database
    Replies: 7
    Last Post: October 24th, 06:19 PM
  5. Replies: 0
    Last Post: April 15th, 01:22 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