Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

arrange by user wish

Newbie
  
Join Date: Sep 2009
Location: Chennai
Posts: 24
#1: Oct 5 '09
i want to arrange a particular field data in user desired order like A,S,B,.... in a query
best answer - posted by ssnaik84
use select...where and union

Expand|Select|Wrap|Line Numbers
  1. select * from table_name where column_name like 'a%'
  2. union
  3. select * from table_name where column_name like 's%'
  4. union
  5. select * from table_name where column_name like 'b%'
ssnaik84's Avatar
Member
  
Join Date: Aug 2009
Location: Bengaluru, India
Posts: 119
#2: Oct 6 '09

re: arrange by user wish

use select...where and union

Expand|Select|Wrap|Line Numbers
  1. select * from table_name where column_name like 'a%'
  2. union
  3. select * from table_name where column_name like 's%'
  4. union
  5. select * from table_name where column_name like 'b%'
Newbie
  
Join Date: Sep 2009
Location: Chennai
Posts: 24
#3: Oct 6 '09

re: arrange by user wish

thank youuuuuuuu. . .i'll try & let u know
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved