Can any one help with some SQL?

Discussion in 'OT Technology' started by rumperpumper, Nov 30, 2005.

  1. rumperpumper

    rumperpumper New Member

    Joined:
    Mar 12, 2002
    Messages:
    2,342
    Likes Received:
    0
    Location:
    Brisbane, QLD, Australia
    :x::noes:

    NEWBIESQL here!
     
  2. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
    i can try :x:
     
  3. rumperpumper

    rumperpumper New Member

    Joined:
    Mar 12, 2002
    Messages:
    2,342
    Likes Received:
    0
    Location:
    Brisbane, QLD, Australia
    Dude if you know any SQL then you should be able to help me here i know its an easy command... refer to the picture attached.

    See how i have done select * from region... how do i make it just show 2 particular items by filtering on for example on "countrycode" 49 & 42?

    [​IMG]
     
  4. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
    SELECT * FROM table WHERE feild1='whatever' OR feild2='whatever'
     
  5. rumperpumper

    rumperpumper New Member

    Joined:
    Mar 12, 2002
    Messages:
    2,342
    Likes Received:
    0
    Location:
    Brisbane, QLD, Australia
    You sir are a star! :bowdown:

    Thanks for your help... i know who to go to on a regular basis now :mamoru:
     

Share This Page