Fetching records which are starting with character "a"

Discussion in 'MySQL' started by technoguy, Feb 11, 2007.

Thread Status:
Not open for further replies.
0
  1. #1
    I have a name field in mysql table, I want to fetch records which starts with character "A" , how to do it?
     
    technoguy, Feb 11, 2007 IP
  2. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #2 
    
Where fieldx like A%
    PHP:
    I think ya use like with a wildcard.
     
    noppid, Feb 11, 2007 IP
Thread Status:
Not open for further replies.