title: using LEFT JOIN and LIKE mysql
body: <p>i have a problem in mysql query.
  this is how my tables looks like:</p>
  
  <pre><code>mysql&gt; select username, specialty from users;
  +----------+------------------+
  | username | specialty        |
  +----------+------------------+
  | JinkX    | php, html, mysql |
  | test1    | html             |
  +----------+------------------+
  
  
  mysql&gt; select name, tags from tasks;
  +----------------+------+
  | name           | tags |
  +----------------+------+
  | fix front page | html |
  +----------------+------+
  </code></pre>
  
  <p>and when i try to do the following query, it works only if the specialty equals exactly the tags. but i want it to work on both</p>
  
  <pre><code>mysql&gt; select tasks.name from users left join tasks on tasks.tags LIKE users.specialty where users.username = 'test1';
  +----------------+
  | name           |
  +----------------+
  | fix front page |
  +----------------+
  
  mysql&gt; select tasks.name from users left join tasks on tasks.tags LIKE users.specialty where users.username = 'JinkX';
  +------+
  | name |
  +------+
  | NULL |
  +------+
  </code></pre>