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  5213 
SELECT * FROM table ORDER BY enumcol IN ('DL','H','A'), enumcol;
See Imran Chaudhry's post at http://dev.mysql.com/doc/refman/5.1/en/select.html vj******@gmail.com wrote:
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Petterson Mikael |
last post by:
Hi,
I have the following package names ( in an xml) that I will transform to
html. I need to sort them.
<package name="se.company.product.subproduct.boam.fpx.testsignals">
<package...
|
by: Arjen |
last post by:
Hello,
Persons is a hashtable which I convert to an array.
Person aPerson = new Person;
Persons.Values.CopyTo( aPerson, 0 );
Now I can access the person items like aPerson.name or...
|
by: Clinton Pierce |
last post by:
I've filled a DataTable with columns that have custom type (a class that I'm
using to keep track of other things, not just a value). When the .Select
method goes to sort this column, how do I let...
|
by: Mark |
last post by:
Assume you have a strongly typed collection of a class called Person. The
strongly typed collection implements IEnumerable so it can be databound to a
server control like a DataGrid. The Person...
|
by: yer darn tootin |
last post by:
Does anyone know the sort expression for a column that's data has been
returned in the format, eg '07 Jul 05'??
The sort expression {..:"dd mmm yy"} doesn't work ( if the column was
returned as...
|
by: **Developer** |
last post by:
I need to sort the columns of a ListView.
Some columns contain dates and others contain integers.
What I did once before is in the Compare method I tried date and if that
failed I did...
|
by: awebguynow |
last post by:
After reading that enum column is very efficient, I'm determined to use
it where I can.
Does anyone have WebApp experiences, that make life easier.
I can see applications for US states, phone...
|
by: PeterWellington |
last post by:
I have a column in a data table that stores enum values and assigns a default
value:
Dim dc As New DataColumn("TestEnumField", GetType(DayOfWeek))
dc.DefaultValue = DayOfWeek.Thursday
When I...
|
by: kgiraldin |
last post by:
Hello,
I have some code commented out in order to make this work. However, I would prefer to use the commented code so my users can SORT on the column heading because I know they are going to want...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
