if entry exist

[chrisleon]

If I have an input box that a user types in an item number, what is the proper syntax in php and mysql to check to see if that item number exist in that particular field of the database? Any help would be great.

ps. if I can use the isset function, please let me know.

thanx

[Sxooter]

select true from table where field='someval';