{"id":202528,"date":"2013-11-18T11:33:02","date_gmt":"2013-11-18T07:33:02","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=202528"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=202528","title":{"rendered":"<span class=\"post_title\">\u041f\u043e\u0438\u0441\u043a \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445 \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432 \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0430\u0446\u0438\u0438 \u0440\u0443\u0441\u0441\u043a\u0438\u0445 \u0442\u0435\u043a\u0441\u0442\u043e\u0432 (\u0424\u0418\u041e) \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439 \u0434\u043b\u044f \u0432\u044b\u0431\u043e\u0440\u043e\u043a \u0432 MySQL<\/span>"},"content":{"rendered":"<div class=\"content html_format\">   \t\u0421\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e, \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0441\u044f \u0441 \u0431\u0430\u043d\u0430\u043b\u044c\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u2014 \u0435\u0441\u0442\u044c \u0431\u0430\u0437\u0430, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0435\u0441\u0442\u044c \u043c\u0430\u0441\u0441\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0424\u0418\u041e, \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u0445 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u0417\u0430\u0447\u0430\u0441\u0442\u0443\u044e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0431\u0435\u0437\u0433\u0440\u0430\u043c\u043e\u0442\u043d\u043e \u0438 \u043d\u0435\u043f\u0440\u0435\u0434\u0441\u043a\u0430\u0437\u0443\u0435\u043c\u043e \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043e. \u0412\u0440\u043e\u0434\u0435 \u0431\u044b \u0438 \u0435\u0441\u0442\u044c \u0413\u041e\u0421\u0422 7.79 (ISO 9), \u043d\u043e \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435 \u0435\u0433\u043e \u0434\u0430\u043b\u0435\u043a\u043e \u043d\u0435 \u0432\u0441\u0435\u0433\u0434\u0430 \u0441\u043e\u0431\u043b\u044e\u0434\u0430\u044e\u0442.<br \/>  \u0417\u0430\u0434\u0430\u0447\u0430 \u2014 \u0435\u0441\u0442\u044c \u0411\u0414 \u0441 \u0437\u0430\u043f\u0438\u0441\u044f\u043c\u0438 (\u043a\u0430\u043a \u043f\u0440\u0430\u0432\u0438\u043b\u043e, \u0424\u0418\u041e) \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u041f\u043b\u043e\u0445\u043e\u0439 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u0422\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u043e \u0440\u0443\u0441\u0441\u043a\u043e\u0439 \u043f\u043e\u0434\u0441\u0442\u0440\u043e\u043a\u0435 \u043f\u043e\u0438\u0441\u043a\u0430 \u0432 \u0432\u044d\u0431-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0438 \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0438\u0437 \u0411\u0414 (MySQL) \u0437\u0430\u043f\u0438\u0441\u0438, <b>\u043f\u043e\u0445\u043e\u0436\u0435 \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435<\/b> \u043d\u0430 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0443.<\/p>\n<p>  <a name=\"habracut\"><\/a><br \/>  \u041f\u0435\u0440\u0432\u0430\u044f \u043c\u044b\u0441\u043b\u044c \u2014 \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0444\u0443\u043d\u043a\u0446\u0438\u044e, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u043b\u0430 \u0431\u044b \u043c\u0430\u0441\u0441\u0438\u0432, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0438\u0439 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u0435 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0439 \u0444\u0440\u0430\u0437\u044b \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439.  <\/p>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u0418\u0441\u0445\u043e\u0434\u043d\u0438\u043a 1, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0439 \u0432\u0437\u0433\u043b\u044f\u043d\u0443\u0442\u044c \u043a\u0430\u043a \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u0431\u0430\u043d\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0442\u0440\u043e\u043a\u0430<\/b><\/p>\n<div class=\"spoiler_text\">\n<pre><code class=\"php\">print_r (r2e (&quot;\u041e\u0447\u0435\u043d\u044c \u043f\u0440\u043e\u0441\u0442\u0430\u044f \u0444\u0440\u0430\u0437\u0430 \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c \u044f\u0437\u044b\u043a\u0435&quot;));  function r2e ($txt)  {   $r=array(mb_strtolower($txt,&quot;windows-1251&quot;));   $r=r2es($r,&quot;\/\u043a\u0441\/i&quot;,array(&quot;x&quot;,&quot;ks&quot;,&quot;cs&quot;));   $r=r2es($r,&quot;\/\u0435\u0439\/i&quot;,array(&quot;ey&quot;,&quot;ei&quot;));   $r=r2es($r,&quot;\/\u043e\u0432\/i&quot;,array(&quot;ov&quot;,&quot;off&quot;));   $r=r2es($r,&quot;\/\u0430\/i&quot;,array(&quot;a&quot;));   $r=r2es($r,&quot;\/\u0431\/i&quot;,array(&quot;b&quot;));   $r=r2es($r,&quot;\/\u0432\/i&quot;,array(&quot;v&quot;,&quot;w&quot;));   $r=r2es($r,&quot;\/\u0433\/i&quot;,array(&quot;g&quot;));   $r=r2es($r,&quot;\/\u0434\/i&quot;,array(&quot;d&quot;));   $r=r2es($r,&quot;\/\u0435\/i&quot;,array(&quot;e&quot;));   $r=r2es($r,&quot;\/\u0451\/i&quot;,array(&quot;yo&quot;,&quot;jo&quot;));   $r=r2es($r,&quot;\/\u0436\/i&quot;,array(&quot;zh&quot;,&quot;z&quot;));   $r=r2es($r,&quot;\/\u0437\/i&quot;,array(&quot;z&quot;,&quot;s&quot;));   $r=r2es($r,&quot;\/\u0438\/i&quot;,array(&quot;i&quot;));   $r=r2es($r,&quot;\/\u0439\/i&quot;,array(&quot;j&quot;,&quot;y&quot;));   $r=r2es($r,&quot;\/\u043a\/i&quot;,array(&quot;k&quot;,&quot;c&quot;));   $r=r2es($r,&quot;\/\u043b\/i&quot;,array(&quot;l&quot;));   $r=r2es($r,&quot;\/\u043c\/i&quot;,array(&quot;m&quot;));   $r=r2es($r,&quot;\/\u043d\/i&quot;,array(&quot;n&quot;));   $r=r2es($r,&quot;\/\u043e\/i&quot;,array(&quot;o&quot;));   $r=r2es($r,&quot;\/\u043f\/i&quot;,array(&quot;p&quot;));   $r=r2es($r,&quot;\/\u0440\/i&quot;,array(&quot;r&quot;));   $r=r2es($r,&quot;\/\u0441\/i&quot;,array(&quot;s&quot;));   $r=r2es($r,&quot;\/\u0442\/i&quot;,array(&quot;t&quot;));   $r=r2es($r,&quot;\/\u0443\/i&quot;,array(&quot;u&quot;));   $r=r2es($r,&quot;\/\u0444\/i&quot;,array(&quot;f&quot;));   $r=r2es($r,&quot;\/\u0445\/i&quot;,array(&quot;h&quot;,&quot;kh&quot;));   $r=r2es($r,&quot;\/\u0446\/i&quot;,array(&quot;c&quot;,&quot;ts&quot;));   $r=r2es($r,&quot;\/\u0447\/i&quot;,array(&quot;ch&quot;));   $r=r2es($r,&quot;\/\u0448\/i&quot;,array(&quot;sh&quot;));   $r=r2es($r,&quot;\/\u0449\/i&quot;,array(&quot;shch&quot;,&quot;sch&quot;,&quot;sh&quot;));   $r=r2es($r,&quot;\/\u044a\/i&quot;,array(&quot;&quot;));   $r=r2es($r,&quot;\/\u044b\/i&quot;,array(&quot;y&quot;));   $r=r2es($r,&quot;\/\u044c\/i&quot;,array(&quot;&quot;));   $r=r2es($r,&quot;\/\u044d\/i&quot;,array(&quot;e&quot;));   $r=r2es($r,&quot;\/\u044e\/i&quot;,array(&quot;u&quot;,&quot;yu&quot;,&quot;ju&quot;));   $r=r2es($r,&quot;\/\u044f\/i&quot;,array(&quot;ya&quot;,&quot;ja&quot;));   return $r;  }  function r2es ($var, $pattern, $splits)  {   $sp=array(); $nsp=array();   foreach ($var as $v)     if (preg_match($pattern,$v)) foreach ($splits as $split) $sp=array_merge($sp,array(preg_replace($pattern,$split,$v)));     else $nsp=array_merge($nsp,array($v));   return array_merge($sp,$nsp);  } <\/code><\/pre>\n<p>  <\/div>\n<\/div>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u0421\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0433\u043e \u043c\u0430\u0441\u0441\u0438\u0432\u0430 \u0438\u0437 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 1<\/b><\/p>\n<div class=\"spoiler_text\">Array<br \/>  (<br \/>  [0] =&gt; ochen prostaya fraza na russkom yazyke<br \/>  [1] =&gt; ochen prostaja fraza na russkom jazyke<br \/>  [2] =&gt; ochen prostaya fraza na russcom yazyce<br \/>  [3] =&gt; ochen prostaja fraza na russcom jazyce<br \/>  [4] =&gt; ochen prostaya frasa na russkom yasyke<br \/>  [5] =&gt; ochen prostaja frasa na russkom jasyke<br \/>  [6] =&gt; ochen prostaya frasa na russcom yasyce<br \/>  [7] =&gt; ochen prostaja frasa na russcom jasyce<br \/>  )  <\/div>\n<\/div>\n<p>  \u0432\u0440\u043e\u0434\u0435 \u0438 \u0445\u043e\u0440\u043e\u0448\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c, \u0434\u0430\u0436\u0435 \u043f\u043e\u0437\u043d\u0430\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e, \u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0439 \u043c\u0430\u0441\u0441\u0438\u0432 \u043d\u0443\u0436\u043d\u043e \u0435\u0449\u0451 \u0438 \u0441\u043a\u043b\u0435\u0438\u0442\u044c \u0432 \u0434\u043e\u0432\u0435\u0441\u043e\u043a \u043a \u0437\u0430\u043f\u0440\u043e\u0441\u0443 \u0432 \u0432\u0438\u0434\u0435   <\/p>\n<pre><code class=\"php\">$sqlstr = &quot;SELECT &lt;smth&gt; FROM &lt;smwhr&gt; WHERE searchField LIKE '%&quot; . implode(&quot;%' OR searchField LIKE '%&quot;,$result) . &quot;%'&quot;; \u043b\u0438\u0431\u043e, \u0435\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0442\u043e\u0447\u043d\u043e\u0435 \u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u0435 $sqlstr = &quot;SELECT &lt;smth&gt; FROM &lt;smwhr&gt; WHERE searchField LIKE '&quot; . implode(&quot;' OR searchField LIKE '&quot;,$result) . &quot;'&quot;; <\/code><\/pre>\n<p>  \u041d\u0443 \u0438 \u0442\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u0438 \u043d\u0430\u0441\u0442\u043e\u0440\u0430\u0436\u0438\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u0437\u0430\u043f\u0440\u043e\u0441 SQL \u0441\u043e\u0432\u0435\u0440\u0448\u0435\u043d\u043d\u043e \u043b\u0435\u0433\u043a\u043e \u043c\u043e\u0436\u0435\u0442 \u0443\u0434\u043b\u0438\u043d\u043d\u0438\u0442\u044c\u0441\u044f \u0432 \u0440\u0430\u0437\u044b.<br \/>  \u0417\u0430\u0442\u043e \u0441 \u043c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0434\u043e\u0440\u0430\u0431\u043e\u0442\u043a\u0430\u043c\u0438 \u0431\u0443\u0434\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u043f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0441 \u043b\u044e\u0431\u044b\u043c \u0434\u0432\u0438\u0436\u043a\u043e\u043c \u0411\u0414.<\/p>\n<p>  \u0420\u0435\u0448\u0435\u043d\u0438\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u0435\u0435 \u2014 MySQL \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u0432\u043c\u0435\u0441\u0442\u043e \u00abSELECT\u2026 WHERE field LIKE &#8216;pattern&#8217;\u00bb \u043f\u0440\u043e\u0434\u0432\u0438\u043d\u0443\u0442\u044b\u0435 \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u00abSELECT\u2026 WHERE field REGEXP &#8216;regexp&#8217;\u00bb, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u043f\u043e\u0438\u0441\u043a \u043f\u043e regexp&#8217;\u0430\u043c.<\/p>\n<p>  \u0418\u0442\u043e\u0433\u043e \u2014 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u044b\u0439 \u043a\u043e\u0434 \u0441\u043e \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043b\u0443\u0447\u0448\u0438\u043c\u0438 \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u0435\u043b\u044f\u043c\u0438 \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 MySQL  <\/p>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u0422\u0430\u043a \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043b\u0443\u0447\u0448\u0435<\/b><\/p>\n<div class=\"spoiler_text\">\n<pre><code class=\"php\">function r2e ($txt)  {   $txt=mb_strtolower($txt,&quot;windows-1251&quot;);   $sr=array(&quot;\u043a\u0441&quot;,&quot;\u0435\u0439&quot;,&quot;\u043e\u0432&quot;,&quot;\u0430&quot;,&quot;\u0431&quot;,&quot;\u0432&quot;,&quot;\u0433&quot;,&quot;\u0434&quot;,&quot;\u0435&quot;,&quot;\u0451&quot;,&quot;\u0436&quot;,&quot;\u0437&quot;,&quot;\u0438&quot;,&quot;\u0439&quot;,&quot;\u043a&quot;,&quot;\u043b&quot;,&quot;\u043c&quot;,&quot;\u043d&quot;,&quot;\u043e&quot;,&quot;\u043f&quot;,&quot;\u0440&quot;,&quot;\u0441&quot;,&quot;\u0442&quot;,&quot;\u0443&quot;,&quot;\u0444&quot;,&quot;\u0445&quot;,&quot;\u0446&quot;,&quot;\u0447&quot;,&quot;\u0448&quot;,&quot;\u0449&quot;,&quot;\u044a&quot;,&quot;\u044b&quot;,&quot;\u044c&quot;,&quot;\u044d&quot;,&quot;\u044e&quot;,&quot;\u044f&quot;);   $se=array(&quot;(x|[kc]s)&quot;,&quot;e[yi]&quot;,&quot;o(v|ff)&quot;,&quot;a&quot;,&quot;b&quot;,&quot;[vw]&quot;,&quot;g&quot;,&quot;d&quot;,&quot;e&quot;,&quot;[yj]o&quot;,&quot;z(h)*&quot;,&quot;[zs]&quot;,&quot;i&quot;,&quot;[jy]&quot;,&quot;[kc]&quot;,&quot;l&quot;,&quot;m&quot;,&quot;n&quot;,&quot;o&quot;,&quot;p&quot;,&quot;r&quot;,&quot;s&quot;,&quot;t&quot;,&quot;u&quot;,&quot;f&quot;,&quot;(k|c)*h&quot;,&quot;(c|ts)&quot;,&quot;ch&quot;,&quot;sh&quot;,&quot;s(h)*(c)*h&quot;,&quot;&quot;,&quot;y&quot;,&quot;&quot;,&quot;e&quot;,&quot;[yj]*u&quot;,&quot;[yj]a&quot;);   return str_replace($sr,$se,$txt);  } <\/code><\/pre>\n<p>  <\/div>\n<\/div>\n<p>  \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442\u0441\u044f \u0441\u0442\u0440\u043e\u043a\u0430 \u0432\u0438\u0434\u0430  <\/p>\n<pre><code class=\"php\">ochen prosta[yj]a fra[zs]a na russ[kc]om [yj]a[zs]y[kc]e <\/code><\/pre>\n<p>  \u0432\u043f\u043e\u043b\u043d\u0435 \u043f\u0440\u0438\u0433\u043e\u0434\u043d\u0430\u044f \u0434\u043b\u044f \u0432\u0441\u0442\u0430\u0432\u043a\u0438 \u0432 \u00abSELECT columns FROM table WHERE searchField REGEXP &#8216;$txt&#8217;\u00bb \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435, \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e, $txt.<\/p>\n<p>  \u0410 \u0447\u0442\u043e \u0441 \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u043c\u0438 \u0421\u0423\u0411\u0414?<br \/>   \u2014 \u041a \u0441\u043e\u0436\u0430\u043b\u0435\u043d\u0438\u044e, \u0441 MSSQL \u0432\u0441\u0435 \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u043d\u0435 \u0441\u0442\u043e\u043b\u044c \u0440\u0430\u0434\u0443\u0436\u043d\u043e \u2014 \u0445\u043e\u0442\u044f \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c CLR-\u043c\u043e\u0434\u0443\u043b\u044c (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <a href=\"http:\/\/www.void-it.ru\/it-snippets\/\u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435-\u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u044b\u0445-\u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0438-.net-\u0432-\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u0445-ms-sql\">\u043e\u0442\u0441\u044e\u0434\u0430<\/a>) \u0438 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 \u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0439.<br \/>   \u2014 \u0421 T-SQL (Oracle) \u0432\u0441\u0435 \u0445\u043e\u0440\u043e\u0448\u043e, \u043f\u043e \u043a\u0440\u0430\u0439\u043d\u0435\u0439 \u043c\u0435\u0440\u0435 \u0441 10G \u0432\u0435\u0440\u0441\u0438\u0438 \u0435\u0441\u0442\u044c REGEXP_LIKE(fieldName, regexpString).<br \/>   \u2014 \u0432 PostgreSQL \u0435\u0441\u0442\u044c \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0434\u0430\u0432\u043d\u043e regexp_matches(fieldName, regexpString).<br \/>   \u2014 \u0432 FireBird \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c SIMILAR TO, \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0434\u043b\u044f \u0441\u043b\u0430\u0432\u043d\u043e \u0440\u0443\u0441\u0441\u043a\u043e\u0439 \u00ab\u0429\u00bb \u0432\u043c\u0435\u0441\u0442\u043e s(h)*(\u0441)*h \u043d\u0443\u0436\u043d\u043e \u0431\u0443\u0434\u0435\u0442 \u043e\u043f\u0438\u0441\u0430\u0442\u044c \u043a\u0430\u043a s(h){0,1}\u00a9{0,1}h \u0438 \u0434\u0430\u043b\u0435\u0435 \u043f\u043e \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0438.    \t<\/p>\n<div class=\"clear\"><\/div>\n<\/p><\/div>\n<p> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"http:\/\/habrahabr.ru\/post\/202528\/\"> http:\/\/habrahabr.ru\/post\/202528\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"content html_format\">   \t\u0421\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e, \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0441\u044f \u0441 \u0431\u0430\u043d\u0430\u043b\u044c\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u2014 \u0435\u0441\u0442\u044c \u0431\u0430\u0437\u0430, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0435\u0441\u0442\u044c \u043c\u0430\u0441\u0441\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0424\u0418\u041e, \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u0445 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u0417\u0430\u0447\u0430\u0441\u0442\u0443\u044e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0431\u0435\u0437\u0433\u0440\u0430\u043c\u043e\u0442\u043d\u043e \u0438 \u043d\u0435\u043f\u0440\u0435\u0434\u0441\u043a\u0430\u0437\u0443\u0435\u043c\u043e \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043e. \u0412\u0440\u043e\u0434\u0435 \u0431\u044b \u0438 \u0435\u0441\u0442\u044c \u0413\u041e\u0421\u0422 7.79 (ISO 9), \u043d\u043e \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435 \u0435\u0433\u043e \u0434\u0430\u043b\u0435\u043a\u043e \u043d\u0435 \u0432\u0441\u0435\u0433\u0434\u0430 \u0441\u043e\u0431\u043b\u044e\u0434\u0430\u044e\u0442.<br \/>  \u0417\u0430\u0434\u0430\u0447\u0430 \u2014 \u0435\u0441\u0442\u044c \u0411\u0414 \u0441 \u0437\u0430\u043f\u0438\u0441\u044f\u043c\u0438 (\u043a\u0430\u043a \u043f\u0440\u0430\u0432\u0438\u043b\u043e, \u0424\u0418\u041e) \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u041f\u043b\u043e\u0445\u043e\u0439 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0435\u0439. \u0422\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u043e \u0440\u0443\u0441\u0441\u043a\u043e\u0439 \u043f\u043e\u0434\u0441\u0442\u0440\u043e\u043a\u0435 \u043f\u043e\u0438\u0441\u043a\u0430 \u0432 \u0432\u044d\u0431-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0438 \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0438\u0437 \u0411\u0414 (MySQL) \u0437\u0430\u043f\u0438\u0441\u0438, <b>\u043f\u043e\u0445\u043e\u0436\u0435 \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435<\/b> \u043d\u0430 \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0443.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-202528","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/202528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=202528"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/202528\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=202528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=202528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=202528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}