Exclude from MySQL SELECT

[051119]

Hi, I have the following query

select vb_user.username as "Username", vb_userfield.field14 as "Mileage" from vb_userfield 

join vb_user on vb_user.userid = vb_userfield.userid

order by vb_userfield.field14 desc[/Code]

and I want to ignore any results from the username [i]Paul[/i] / userid [i]1432[/i] (they are the same thing). Can anyone advise how to do this, I've tried adding [i]where !=[/i] but this doesn't seem to work?

 

Thanks

[Mchl]

Does this work?

SELECT vb_user.username AS "Username", vb_userfield.field14 AS "Mileage" 
FROM vb_userfield
INNER JOIN vb_user 
ON vb_user.userid = vb_userfield.userid
WHERE vb_user.username != 'Paul'
ORDER BY vb_userfield.field14 DESC

[051119]

That's great, thanks very much!