SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Sort by column

  1. #1
    Node mutilating coot timnz's Avatar
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    516
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Sort by column

    I'm looking to be able to limit my results where the column, lastname, begins with a certain letter.

    ie, in words:
    SELECT * FROM athletes WHERE first letter of lastname = 'a'

    Any insights appreciated

  2. #2
    You talkin to me? Anarchos's Avatar
    Join Date
    Oct 2000
    Location
    Austin, TX
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    WHERE lastname LIKE 'a%'

  3. #3
    Node mutilating coot timnz's Avatar
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    516
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Arr, where is the challenge in that! Thanks Anarchos, my friend I'm doing this for will be very happy.


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
  •