Necesito una consulta donde el WHERE es un like (otro select SELECT), pero la SQL me da error. Como se haria
la parte que me da error esta en negrita
Código:
$extra_fields_query = tep_db_query("SELECT *
FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef
WHERE category_id like '%" . $current_category_id .",%'
OR category_id=". $current_category_id ."
OR category_id='all'
OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id =".$current_category_id .")
OR pef.category_id like'% (SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id =".$current_category_id .")%'
ORDER BY products_extra_fields_order");
Gracias de antemano.