表1:products
具有以下字段:
products_id
products_price
products_status = 1( In Stock )
products_url
表2:products_description
具有以下字段:
products_id(equals products_id in table products )
products_name
我想得到五个相关的产品名称(库存(及其价格,这与产品名称的某些部分相匹配。例如,产品名称为$product_name
。我想了解五种相关产品的名称(库存(和价格。
$query = "select products_id , products_price, products_name
from products p
left join products_description pd on p.products_id=pd.products_id and products_status = 1 and ....";`
匹配是这样的:如果产品名称是True Blood Season 1 DVD
,我想展示以"真爱季节"开头的五个项目。产品名称可能还有其他名称。不仅仅是真爱季节
如何在SQL中编写?
SELECT `products_id`, `products_price`, `products_name` FROM `products` p
LEFT JOIN `products_description` pd ON p.products_id = pd.products_id
WHERE `products_name` LIKE 'True Blood Season%' AND `products_status` = 1
ORDER BY `products_name` LIMIT 5;
应该是上面的内容,但这只是我的想法。