Chapter 7. Sorting Query Results


    Section 7.0.  Introduction

    Recipe 7.1.  Using ORDER BY to Sort Query Results

    Recipe 7.2.  Using Expressions for Sorting

    Recipe 7.3.  Displaying One Set of Values While Sorting by Another

    Recipe 7.4.  Controlling Case Sensitivity of String Sorts

    Recipe 7.5.  Date-Based Sorting

    Recipe 7.6.  Sorting by Calendar Day

    Recipe 7.7.  Sorting by Day of Week

    Recipe 7.8.  Sorting by Time of Day

    Recipe 7.9.  Sorting Using Substrings of Column Values

    Recipe 7.10.  Sorting by Fixed-Length Substrings

    Recipe 7.11.  Sorting by Variable-Length Substrings

    Recipe 7.12.  Sorting Hostnames in Domain Order

    Recipe 7.13.  Sorting Dotted-Quad IP Values in Numeric Order

    Recipe 7.14.  Floating Values to the Head or Tail of the Sort Order

    Recipe 7.15.  Sorting in User-Defined Orders

    Recipe 7.16.  Sorting ENUM Values




MySQL Cookbook
MySQL Cookbook
ISBN: 059652708X
EAN: 2147483647
Year: 2004
Pages: 375
Authors: Paul DuBois

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net