SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help on MySQL query

    Hi folks..

    Which would be the syntax for a MySQL query that does something like this:

    "SELECT * FROM domains WHERE domain STARTS WITH 'a'"

    I mean, select something where the value starts with a given letter.

    Thanks in advance!

  2. #2
    Super Ninja Monkey Travis's Avatar
    Join Date
    Dec 2001
    Location
    Sioux City, Iowa
    Posts
    691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHP Code:
    "SELECT * FROM domains WHERE domain LIKE 'a%'" 
    I believe thats it.
    Travis Watkins - Hyperactive Coder
    My Blog: Realist Anew
    Projects: Alacarte - Gnome Menu Editor

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yep, that was it... thanks dude!


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
  •