Convert a MySQL 4+ query to MySQL
Hoping someone can help me out converting a query so that it works in MySQL 3.23 - it includes a sub select so I believe that's what the problem is.
Is it a case of breaking it up in to two seperate queries?
FROM products_extra_fields pef
WHERE category_id LIKE '% 3,%'
OR category_id =3
OR category_id = 'all'
OR pef.category_id = (
FROM categories AS c
WHERE c.categories_id =3 )
ORDER BY products_extra_fields_order
Any help much appreciated.