select prod_id, prod_label, prod_price, prod_pic, fk_categ, fk_subcateg from table_prod where prod_code in (27830,30027b) order by rand()

Unknown column '30027b' in 'where clause'