SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi all!

    What should I replace <empty> with if I want only rows where "topic" is not empty?

    Code:
    mysql_query(SELECT * FROM table WHERE topic != <empty>);
    Last edited by M. Johansson; Feb 24, 2001 at 08:27.

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    SELECT *
      FROM table
     WHERE topic IS NOT NULL
    That should do the trick.

  3. #3
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Alrighty - thanks!


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
  •