Re: Re: Problem with MySQL Query

* Thus wrote Mikael Jansson (mikael.jansson@activemind.se): > Hi Phil, > What I can see in your question there is a missing space between fieldname > "type" and the operator != > > I tested on my machine and it works fine when using both != and <> > operators, but it will not work with the NOT operator. > > Hope the missing space will do some good. there is no difference between: select * from table where column !="value" vs. select * from table where column != "value" At this point, I would inspect the data to see if it is really the value that I'm looking for. Curt -- "I used to think I was indecisive, but now I'm not so sure."