how to search mysql table

[viveleroi0]

I have am developing a shopping cart storefront and admin backend and I am trying to figure out, what is the best way to search all of the fields in a certain database, except one? I have multiple product tables, and a shopping cart table, but I want someone to be able to keyword search all of the products tables, without results showing from the shopping cart.
How, and can this be done?

[Frag]

It would help to show your table design. That way you don't get some inane SQL statment

Frag

[viveleroi0]

Table: Carts
| ID | Products | Price | etc

Table: Vintage Products
| ID | Name | Description | Price | etc