#1
  1. No Profile Picture
    ads
    Guest
    Devshed Newbie (0 - 499 posts)
    I have got a table with column field "varchar" type storing name of the users. I would like to display their names alphabetically either ascending or descending. How to do this?
    Thanks
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    select * from table_name order by field_name [asc|desc]
  4. #3
  5. No Profile Picture
    ads
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks rod it works.

Similar Threads

  1. Replies: 0
    Last Post: January 3rd, 2004, 09:33 AM
  2. Can a certain field type do this .....
    By mav8 in forum MySQL Help
    Replies: 3
    Last Post: July 25th, 2003, 05:58 AM
  3. how to sort varchar column as numbers
    By djhun in forum MySQL Help
    Replies: 4
    Last Post: August 20th, 2002, 09:39 PM
  4. field or column widths : how to decide?
    By sc in forum MySQL Help
    Replies: 2
    Last Post: November 6th, 2000, 11:28 PM
  5. Replies: 0
    Last Post: June 9th, 2000, 01:02 PM

IMN logo majestic logo threadwatch logo seochat tools logo