[Resolved] SQL Advice

[furious5]

I am struggling to remember the relevant SQL for the following scenario - can anyone job my memory.

I am wanting to select all fields where skills = skills but not return any results which contain skills1?

I guess the SQL should be something like this:

"SELECT * FROM job WHERE skills = $skills";

But how do I then filter out skills1?

[OhLordy]

"SELECT * FROM job WHERE skills = $skills && skills!=$skills1";
HTH Rob

[kevinsequeira]

if skills is a numeric value

"SELECT * FROM job WHERE skills = ".$skills." AND skills <> ".$skills1; 

if not numeric

"SELECT * FROM job WHERE skills = '".$skills."' AND skills <> '".$skills1."'"; 

reg
kevin

[furious5]

Thank you, just what I needed.