MYSQL field is empty?

Discussion in 'MySQL' started by Weirfire, Sep 19, 2005.

0
  1. #1
    Is it possible to run a query to return all results where a certain field is not empty?
     
    Weirfire, Sep 19, 2005 IP
  2. JoeO

    JoeO Peon

    Messages:
    431
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    0
    #2
    sure !=NULL or !="" ... depending on how its empty
     
    JoeO, Sep 19, 2005 IP
  3. Weirfire

    Weirfire Language Translation Company

    Messages:
    6,979
    Likes Received:
    365
    Best Answers:
    0
    Trophy Points:
    280
    #3
    I just read on another forum this solution

    SELECT * FROM table_name WHERE column_name > '';

    for those who come across this thread in the future.


    Thanks JoeO :)
     
    Weirfire, Sep 19, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    ISNULL([columnname]) is a good operator in MySQL as well.
     
    digitalpoint, Sep 19, 2005 IP
  5. Weirfire

    Weirfire Language Translation Company

    Messages:
    6,979
    Likes Received:
    365
    Best Answers:
    0
    Trophy Points:
    280
    #5
    So to use that for my problem could you put

    SELECT * FROM table_name WHERE !(ISNULL([columnname]));
     
    Weirfire, Sep 19, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    Probably just easier to do this:

    SELECT * FROM table_name WHERE NOT ISNULL([columnname]);
    Code (sql):
     
    digitalpoint, Sep 19, 2005 IP
  7. Weirfire

    Weirfire Language Translation Company

    Messages:
    6,979
    Likes Received:
    365
    Best Answers:
    0
    Trophy Points:
    280
    #7
    Cheers Shawn :)
     
    Weirfire, Sep 19, 2005 IP
  8. kineticdc

    kineticdc Peon

    Messages:
    347
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Thanks Shawn for the answer
     
    kineticdc, Sep 1, 2008 IP