Re: Help with SQL Syntax

>> what I'm trying to do: Select all fields where a serial is a certain >> number and a field does not match a certain string. >> >> select * from table where serial = "1" and status not matches "killed" perhaps you mean "contains": select ... status not matches "*killed*"