select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "2 %" || CONCAT_COLLECTION like "% 2" || CONCAT_COLLECTION like "2" || CONCAT_COLLECTION like "% 2 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;2 %&quot; || CONCAT_COLLECTION like &quot;% 2&quot; || CONCAT_COLLECTION like &quot;2&quot; || CONCAT_COLLECTION like &quot;% 2 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>15<br>select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "3 %" || CONCAT_COLLECTION like "% 3" || CONCAT_COLLECTION like "3" || CONCAT_COLLECTION like "% 3 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;3 %&quot; || CONCAT_COLLECTION like &quot;% 3&quot; || CONCAT_COLLECTION like &quot;3&quot; || CONCAT_COLLECTION like &quot;% 3 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>54<br>select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "4 %" || CONCAT_COLLECTION like "% 4" || CONCAT_COLLECTION like "4" || CONCAT_COLLECTION like "% 4 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;4 %&quot; || CONCAT_COLLECTION like &quot;% 4&quot; || CONCAT_COLLECTION like &quot;4&quot; || CONCAT_COLLECTION like &quot;% 4 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>41<br>select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "5 %" || CONCAT_COLLECTION like "% 5" || CONCAT_COLLECTION like "5" || CONCAT_COLLECTION like "% 5 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;5 %&quot; || CONCAT_COLLECTION like &quot;% 5&quot; || CONCAT_COLLECTION like &quot;5&quot; || CONCAT_COLLECTION like &quot;% 5 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>2<br>select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "31 %" || CONCAT_COLLECTION like "% 31" || CONCAT_COLLECTION like "31" || CONCAT_COLLECTION like "% 31 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;31 %&quot; || CONCAT_COLLECTION like &quot;% 31&quot; || CONCAT_COLLECTION like &quot;31&quot; || CONCAT_COLLECTION like &quot;% 31 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>21<br>select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "40 %" || CONCAT_COLLECTION like "% 40" || CONCAT_COLLECTION like "40" || CONCAT_COLLECTION like "% 40 %" ) 
order by CHAR_P_GENRE ASC 
<hr class='adodb-debug'>(mysqli):  select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE=&quot;1&quot; AND (CONCAT_COLLECTION like &quot;40 %&quot; || CONCAT_COLLECTION like &quot;% 40&quot; || CONCAT_COLLECTION like &quot;40&quot; || CONCAT_COLLECTION like &quot;% 40 %&quot; ) order by CHAR_P_GENRE ASC  &nbsp; <hr class='adodb-debug'><br>329<br>