mySQL连接表如果表1列值LIKE表2列值

Table 1

+-------+--------+--------+
| name  |  age   | gender |
+-------+--------+--------+
| mark  |  20    |  male  |
| john  |  22    |  male  |
| jenny |  21    | female |
+-------+--------+--------+
+-------+--------+--------+
| name  |