Professional Web Applications Themes

sort on column type enum - MySQL

Hi all I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD', 'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and the rest . Thanks in advance...

  1. #1

    Default sort on column type enum

    Hi all

    I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD',
    'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and
    the rest .

    Thanks in advance

    vjyanand@gmail.com Guest

  2. #2

    Default Re: sort on column type enum

    com wrote: 

    ORDER BY column='DL' DESC, column='H' DESC, column='A' DESC

    HTH
    Kai
    Kai Guest

Similar Threads

  1. DataGrid 2 Column Sort
    By Duderr in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: November 15th, 03:06 PM
  2. probleme UPDATE data de type ENUM
    By Yves in forum MySQL
    Replies: 4
    Last Post: February 21st, 07:40 AM
  3. Sort DataGrid Column
    By mdeaton in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: November 8th, 10:59 PM
  4. Sort on Date Column
    By Alan Z. Scharf in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: December 5th, 09:38 PM
  5. Replies: 1
    Last Post: September 9th, 07:16 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