Заметки IT программиста http://178.140.10.58:8080/ 2026-04-17T15:53:12+00:00 http://178.140.10.58:8080/ http://178.140.10.58:8080/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2016-04-08T21:08:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://178.140.10.58:8080/doku.php?id=sql:mysql:select:field_in_set <div class="tags"><span> <a href="http://178.140.10.58:8080/doku.php?id=tag:mysql&amp;do=showtag&amp;tag=mysql" class="wikilink1 tag label label-default mx-1" title="tag:mysql" rel="tag"><span class="iconify" data-icon="mdi:tag-text-outline"></span> mysql</a>, <a href="http://178.140.10.58:8080/doku.php?id=tag:sql&amp;do=showtag&amp;tag=sql" class="wikilink1 tag label label-default mx-1" title="tag:sql" rel="tag"><span class="iconify" data-icon="mdi:tag-text-outline"></span> sql</a>, <a href="http://178.140.10.58:8080/doku.php?id=tag:select&amp;do=showtag&amp;tag=select" class="wikilink1 tag label label-default mx-1" title="tag:select" rel="tag"><span class="iconify" data-icon="mdi:tag-text-outline"></span> select</a> </span></div> <h1 class="sectionedit1" id="field_in_set">FIELD_IN_SET()</h1> <div class="level1"> <p> Бывают случаи когда нада произвести поиск по полю с разделителем &quot;,&quot;, для этих целей легко подойдет функция FIELD_IN_SET() </p> <pre class="code sql"><span class="kw1">SELECT</span> <span class="sy0">*</span> <span class="kw1">FROM</span> tbl_table <span class="kw1">WHERE</span> FIELD_IN_SET<span class="br0">&#40;</span><span class="st0">'search-word'</span><span class="sy0">,</span> col<span class="br0">&#41;</span>;</pre> </div> <!-- EDIT{&quot;target&quot;:&quot;section&quot;,&quot;name&quot;:&quot;FIELD_IN_SET()&quot;,&quot;hid&quot;:&quot;field_in_set&quot;,&quot;codeblockOffset&quot;:0,&quot;secid&quot;:1,&quot;range&quot;:&quot;27-&quot;} -->