SitePoint Sponsor

User Tag List

Results 1 to 23 of 23

Threaded View

  1. #1
    PHP Programmer QReyes's Avatar
    Join Date
    Oct 2001
    Location
    Philippines
    Posts
    698
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL: Proper sorting of a column

    -------------
    Title column
    -------------
    SitePoint
    1-2-3 Website
    The Matrix
    'San Pedro

    What I would like to do is to sort the Title column correctly ignoring the symbols, article, and have the number "1" be sorted as "one." If properly sorted, it should result to this:

    -------------
    Title column
    -------------
    The Matrix (Matrix, The)
    1-2-3 Website (One-Two-Three Website)
    'San Pedro (San Pedro)
    SitePoint (SitePoint)

    Is this possible with MySQL? If it is not, how can I solve this sorting issue without changing the name?
    Last edited by QReyes; Apr 28, 2005 at 23:46. Reason: Added the question mark icon.
    The Star Circle Quest Community - Community website for SCQ fans.
    Telebisyon.net - Reference guide to TV series shown in the Philippines.
    Lyrics Server Online! - All the lyrics you can get on one website.


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
  •