friendly Posted November 6, 2003 Share Posted November 6, 2003 I am doing a SELECT FROM function on one table, with a LEFT JOIN. I would like to do a MATCH AGAINST(table2.column). I\'ve attached the code I\'ve been using below. SELECT pmw_products.*, pmw_manufacturers.description AS manu_description FROM pmw_products LEFT JOIN pmw_manufacturers ON pmw_products.manufacturer=pmw_manufacturers.id, WHERE MATCH(manu_description) AGAINST(\'$search_string\') Does anyone know if this is possible and how to do it. Cheers[/img] Quote Link to comment https://forums.phpfreaks.com/topic/1305-mysql-select-from-two-tables/ Share on other sites More sharing options...
Barand Posted November 6, 2003 Share Posted November 6, 2003 Performing ... pmw_products LEFT JOIN pmw_manufacturers ... will give you all products with null in the manu_description field where a product has no manufacturer. As you are selecting a particular value for manu_description, the LEFT JOIN is pointless, may as well do a normal INNER JOIN. Quote Link to comment https://forums.phpfreaks.com/topic/1305-mysql-select-from-two-tables/#findComment-4335 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.