[Vanilja]

Hi.
So let's take this table for example, we call it Messages


By default, receiver value is always NULL.
I am trying to display all Messages where receiver is NULL.
But how?

Since this wont work.

Code

System.out.println("1. Read messages 2. Send message 0. Quit");
            answer=reader.nextInt();
            reader.nextLine();
            if(answer==1)
            {
                try{
                    st = con.createStatement();
                    rs = st.executeQuery("SELECT Message FROM Messages WHERE Receiver = IS NULL");
                    while (rs.next()) {
                        System.out.println(rs.getString(1));
                    }
                }catch(SQLException ex){
                    System.out.println(ex.toString());

This is the error message
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS NULL' at line 1

[Kain_12]

You should type Receiver = NULL, not Receiver = IS NULL. That is the mistake.

[Vanilja]

You should type Receiver = NULL, not Receiver = IS NULL. That is the mistake.

Tried it, does not display anything. That's the problem.

Just wondering, does it matter what type it is? It is int right now, but it should not matter since it's NULL by default right?



E: Working now, it had to be RECEIVER IS NULL, just had to remove the =.

[nOrr]

You should type Receiver = NULL, not Receiver = IS NULL. That is the mistake.

No it's not.

E: Working now, it had to be RECEIVER IS NULL, just had to remove the =.

There we go.

Alternatively, the notation <> usually works, too. That means "is different from", e.g. WHERE USER_ID <> 42.