sql中的Inner join和Like子句
sql中的Inner join和Like子句
提问于 2014-03-23 23:01:24
我想在我的内部连接语句中使用Like进行搜索。
搜索：
SELECT *
FROM CARS
WHERE (plate_no LIKE '%$search%' OR eng_no LIKE '%$search%'
or chass_no like '%$search%' or car_year LIKE '%$search%'
or car_brand LIKE '%$search%' or car_model LIKE '%La%'
or horse_power LIKE '%$search%')
AND status='sold'内部联接：
SELECT cars.
plate_no, cars.car_condition, cars.photo_path, cars.car_year,
cars.car_brand, cars.car_model, transaction.actual_price, customer_maintenance.id
FROM
`cars`
INNER JOIN
transaction ON (cars.id = transaction.car_id)
INNER JOIN
customer_maintenance ON (transaction.customer_id = customer_maintenance.id)
WHERE
status = 'sold'回答 2
Stack Overflow用户
发布于 2014-03-23 23:28:34
你在找这样的东西吗？：
SELECT cars.plate_no,
cars.car_condition,
cars.photo_path,
cars.car_year,
cars.car_brand,
cars.car_model,
transaction.actual_price,
customer_maintenance.id
FROM cars
INNER JOIN transaction
ON transaction.car_id = cars.id
INNER JOIN customer_maintenance
ON transaction.customer_id = customer_maintenance.id
WHERE cars.status = 'sold'
AND ( cars.plate_no LIKE '%$search%'
OR cars.eng_no LIKE '%$search%'
OR cars.chass_no LIKE '%$search%'
OR cars.car_year LIKE '%$search%'
OR cars.car_brand LIKE '%$search%'
OR cars.car_model LIKE '%La%'
OR cars.horse_power LIKE '%$search%' ) Stack Overflow用户
发布于 2014-03-23 23:43:16
同样有效的是扩展INNER JOIN子句的匹配表达式，只需将其替换为更复杂的表达式：
SELECT *
FROM cars
INNER JOIN transaction
ON transaction.car_id = cars.id AND car.brand like '%search%'
INNER JOIN customer_maintenance
ON transaction.customer_id = customer_maintenance.id
WHERE cars.status = 'sold' 将其放入WHERE子句中会产生相同的结果。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/22592555
复制相关文章
相似问题
腾讯云开发者
