我在

mysql查詢中有問題.

這是我的表格的樣子：

mysql> select username, specialty from users;

+----------+------------------+

| username | specialty |

+----------+------------------+

| JinkX | php, html, mysql |

| test1 | html |

+----------+------------------+

mysql> select name, tags from tasks;

+----------------+------+

| name | tags |

+----------------+------+

| fix front page | html |

+----------------+------+

當我嘗試執行以下查詢時,只有當專業完全等于標簽時,它才有效.但我希望它能同時發揮作用

mysql> select tasks.name from users left join tasks on tasks.tags LIKE users.specialty where users.username = 'test1';

+----------------+

| name |

+----------------+

| fix front page |

+----------------+

mysql> select tasks.name from users left join tasks on tasks.tags LIKE users.specialty where users.username = 'JinkX';

+------+

| name |

+------+

| NULL |

+------+

總結

以上是生活随笔為你收集整理的mysql left join like_使用LEFT JOIN和LIKE mysql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。