[Resolved] Try to exclude values in a result

[sgtpepper]

Hello,

I am trying to get a set of results....but exclude certain Id number from the results. I am using the following query.....but I am still seeing Id 185332. Can you tell me what I am doing wrong?

Thanks!

<php>
SELECT Id FROM mastertable WHERE town = 'Springfield' or town = 'Lebanon' and Id NOT LIKE '185332';
</php>

[Roger_Ramjet]

Several ways to do this, depends on circumstances. See the comparison operators for more info.

In this particular case

SELECT Id FROM mastertable WHERE town = 'Springfield' or town = 'Lebanon' and Id<>185332;

<> means not equal. Could also use NOT IN (value list), for multiple id exclusion.