Professional Web Applications Themes

Problem with not equals - MySQL

I'm having a problem with != in a simple query. Here is the query: select testScore, reqPass from tests where stat!='D' The stat field is a varchar 4. It currently has null in all values. The query returns none of the 2456 rows. What the heck am I doing wrong or not seeing. Thanks for any help you can provide!!!...

  1. #1

    Default Problem with not equals

    I'm having a problem with != in a simple query. Here is the query:

    select testScore, reqPass
    from tests
    where stat!='D'

    The stat field is a varchar 4. It currently has null in all values.
    The query returns none of the 2456 rows. What the heck am I doing
    wrong or not seeing. Thanks for any help you can provide!!!

    bdehoff@gmail.com Guest

  2. #2

    Default Re: Problem with not equals

    On 28 Feb, 13:29, com wrote: 

    Try
    select testScore, reqPass
    from tests
    where stat!='D' OR stat IS NULL

    Captain Guest

  3. #3

    Default Re: Problem with not equals

    On Feb 28, 8:35 am, "Captain Paralytic" <com>
    wrote: 


    >
    > Try
    > select testScore, reqPass
    > from tests
    > where stat!='D' OR stat IS NULL[/ref]

    Thanks, but other values are possible in this field. I just want to
    pull anything that is not D.

    bdehoff@gmail.com Guest

Similar Threads

  1. do we have something like equals in Java?
    By sujikrishna in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 15th, 12:58 PM
  2. Count equals to ..?
    By Dennis in forum MySQL
    Replies: 3
    Last Post: September 20th, 09:15 AM
  3. Illustrator CS and Network Equals no Saves
    By Nicholas_Opels@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: May 24th, 08:36 PM
  4. Replies: 2
    Last Post: November 10th, 07:10 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139