LIKE and NOT LIKE

jowatkins

Hi,

I have the following query which is checking for a particular comment in a database, but the NOT LIKE part of it just won't work.

$getcomment_query = "SELECT * FROM HWBugComments WHERE probno='$probno' AND ";
$getcomment_query .= "(comment LIKE '%Fix Added%'AND comment NOT LIKE '%Fix Rejected')";
$getcomment_result = mysql_query ($getcomment_query);

The Comment will look like this in the db:
Fix Added <br/>
Unit Fixed comments <br/>
Fix Accepted

I want to retrieve all records without the last bit. Any Ideas?

Thanks in advance. Jo.

Lars_Berg

Missing % at the end maybe?

$getcomment_query .= "(comment LIKE '%Fix Added%'AND comment NOT LIKE '%Fix Rejected%')";

michael

If you're choosing from one of three options, I think your database would be better served by using a tinyint.
0 = unset
1 = added
2 = updated
3 = rejected

Searching this way would be much simpler.

But in pseudo, your request would be.. where value like "%added%" or value like "%updated%"

Not = rejected is assumed if you say it can only be the first two, and mutually exclusive.

It's when you can have added and rejected in the same line that you run into trouble.