Jump to content

Archived

This topic is now archived and is closed to further replies.

friendly

mySQL: SELECT FROM TWO TABLES

Recommended Posts

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]

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.