php - SQL LIKE 子句

Question

要根据职位和经验搜索员工，如果表包含职位和经验等字段，我们可以简单地这样做

$sql="select FirstName, title, experience from applied_employee where title like '$_POST[jobtitle]' and experience like '$_POST[experiance]'";

但是当表 Applied_employee 只包含职位 ID 和员工 ID 时要编写什么查询。我是 SQL 查询和编程的新手。提前致谢。

Answer 1

以下查询对我有用

    SELECT e.FirstName, j.title   FROM applied_employee ae, employees e, jobs j
WHERE ae.employeeID = e.emp_id
AND j.jobid = ae.a_jobid
AND e.FirstName LIKE  '$_POST[FirstName]'
AND j.title   LIKE  '$_POST[title]';