select *
from products
where prodid= 10