php - Mysql 选择多个查询

Question

我有这张表:

------------------------------
|ID | name   | employee_code |
------------------------------
|24 | Robert |    20234      |
------------------------------

并且

-------------------------------------
|ID |   job_code   |     team       |
-------------------------------------
|24 | 241124 | Robert, Eduard, Etc. |
-------------------------------------

我想通过员工代码在第二个表中搜索，我尝试这样的操作:

$sql=mysql_query("SELECT * FROM works WHERE (SELECT name FROM employee WHERE employee_code LIKE '%".$_GET['employee_code']."%' AS searchname) team Like %searchname% ");

结果:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Answer 1

尝试这个查询 -

$employee_code = mysql_real_escape_string($_GET['employee_code']);

$sql=mysql_query("SELECT w.* 
                  FROM employee e
                  JOIN works w 
                  ON w.team LIKE CONCAT('%', e.name ,'%')
                  WHERE employee_code LIKE '%$employee_code%'");

查看此 SQLFiddle 示例 - http://sqlfiddle.com/#!2/8f8b7/1