sql like first and second
<pre><code>address_land
------------------------------------------------|
taitan moudo yan-chi 633, 644; mei-li 759-1, 752
taipei chinying josan 522,666
taidung lugu  a-pei 500-3
</code></pre>

<hr>

<h2>land_table</h2>

<pre><code>land   |code
---------------
yan-chi| AD551
mei-li | AG666
jo-sang| EH332
a-pei  | GX112
</code></pre>

<hr>

<p>I can</p>

<pre><code>select address_land from ... where address_land like '%'+[land]+'%'+[land]+'%' 
</code></pre>

<p>how can I save the first [land], AND second [land]?</p>

<p>when I command 'like' taitan moudo yan-chi 633, 644; mei-li 759-1, 752  </p>

<pre><code>select address_land, land_table.[land] 
from ... ,land_table
where address_land like '%'+[land]+'%'+[land]+'%' 
</code></pre>

<p>I can find the one but not both two?
what should I do?</p>