MySQL 从一个表中选择 id 并从另一个表中选择其值进行搜索

Select id from one table and its value from another table to search

提问by Montiyago

I have two tables named companyand customers.

我有两个名为company和 的表customers。

In companytable there are 3 fields ID, Company, and Typeas:

在company表中有3个字段ID，Company以及Type为：

ID    Company    Type
1     ABC        Running

2     XYZ        Current

Now again in customerstable I submitted the value of company and customers, but here the value of company is submitted as an IDas:

现在再次在customers表中提交公司和客户的价值，但这里公司的价值提交ID为：

Company     Customer Name
1              monty

2             sandeep

now I want to search the company name in customer table but when i put company name in search box its showing nothing because the value of company name is in ID form in customer tabe.how can i achieve it.

现在我想在客户表中搜索公司名称，但是当我将公司名称放入搜索框中时，它什么也不显示，因为公司名称的值是客户表中的 ID 形式。我该如何实现。

Here is my query for search:

这是我的搜索查询：

$sql = "Select * from customers where name like '%$term%' or location like '%$term%' or company like '%$term%'";

回答by Mahmoud Gamal

By JOINing the two tables:

通过JOINing 两个表：

Select * 
from customers AS cust
INNER JOIN companies AS comp ON cust.Company = comp.Id
where comp.location like '%$term%' 
   or comp.company like '%$term%'

回答by Ankur Dhanuka

try this

SELECT co.*, cu.* FROM company as co, customers as cu where co.company_id = cu.company_id and co.company_name = '%$term%';