Retrieving only first value from Mysql table

Discussion in 'MySQL' started by computerzworld, Aug 25, 2008.

0
  1. #1
    Hello,
    I am having one table in mysql which is having the fields for the invitation along with the userId. I want to retrieve only first record for a particular userId using query at a time. What's the syntax of retrieving only one value from the table using Mysql query? please help me. Thanks in advance.
     
    computerzworld, Aug 25, 2008 IP
  2. guruguy

    guruguy Active Member

    Messages:
    553
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Is it: SELECT whatever_column FROM table WHERE userid = 'joe' LIMIT 1
    or are you looking for something else?
     
    guruguy, Aug 26, 2008 IP