Question: For example, I have a 100 row table with a `varchar` column.

I run these queries:

```
SELECT count(*) FROM myTable WHERE myText LIKE '%hello%'
SELECT count(*) FROM myTable WHERE myText NOT LIKE '%hello%'

```

I am not getting a total count of 100. It is not picking up some of the rows for some reason. Why would this be happening?

Answer: 
Check for `NULL` values, neither `LIKE` nor `NOT LIKE` will count these.
It may be possible that some of the data in field do not have the word "Hello" in them. If you want to display all the row, just use 

```
select count(*) from mytable;

```

without using where clause.