Question: I am trying to select database entries where a field is filled in. The database has 2 ways of inserting data, one enters a comment and one does not, i am lookin to only select rows that have comments filled in.

```
 $requete = "SELECT * FROM daysoff WHERE comment = true ORDER BY id";

```

where is this going wrong? or what is the correct way to do this?

Answer: 
You may try:

```
$requete = "SELECT * FROM daysoff WHERE comment IS NOT NULL ORDER BY id";

```
You must try this 

```
$requete = "SELECT * FROM daysoff WHERE comment IS NOT NULL AND comment != '' ORDER BY id";

```