+ Reply to Thread
Results 1 to 2 of 2

Thread: query problem

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    28

    query problem

    I have that simple select query :
    Code:
    SELECT * FROM `conversation` WHERE `deleted` != '1';
    And my deleted be default is null or some user id, but for some reason this query always returns me 0 rows, i also tried <> but still no luck , so what`s wrong ?

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    15
    Here is the solution :
    Code:
    SELECT * FROM conversation WHERE deleted <> 1 OR deleted IS NOT NULL

+ Reply to Thread

Tags for this Thread

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