HTML code for sharing source code

HTML Copy To Clipboarddone!

<div class="highlight" style="background: #f8f8f8"><pre style="line-height: 125%"><div id="lc1">mysql&gt; select geoname_id from alternames where match(name) against(&#39;+copan*&#39; in boolean mode) group by geoname_id order by geoname_id;
</div><div id="lc2">+------------+
</div><div id="lc3">| geoname_id |
</div><div id="lc4">+------------+
</div><div id="lc5">|     680926 | 
</div><div id="lc6">|     705048 | 
</div><div id="lc7">|    1123168 | 
</div><div id="lc8">|    1132168 | 
</div><div id="lc9">|    1137376 | 
</div><div id="lc10">|    1143344 | 
</div><div id="lc11">|    1144896 | 
</div><div id="lc12">|    1144897 | 
</div><div id="lc13">|    1144898 | 
</div><div id="lc14">|    1144921 | 
</div><div id="lc15">|    1147191 | 
</div><div id="lc16">|    1350000 | 
</div><div id="lc17">|    1424747 | 
</div><div id="lc18">|    1447417 | 
</div><div id="lc19">|    1447421 | 
</div><div id="lc20">|    1448775 | 
</div><div id="lc21">|    1456560 | 
</div><div id="lc22">|    1456628 | 
</div><div id="lc23">|    1457203 | 
</div><div id="lc24">|    1462039 | 
</div><div id="lc25">|    1467739 | 
</div><div id="lc26">|    1470637 | 
</div><div id="lc27">|    1472468 | 
</div><div id="lc28">|    1472538 | 
</div><div id="lc29">|    1474424 | 
</div><div id="lc30">|    1476855 | 
</div><div id="lc31">|    3185868 | 
</div><div id="lc32">|    3377791 | 
</div><div id="lc33">|    3530254 | 
</div><div id="lc34">|    3584988 | 
</div><div id="lc35">|    3586898 | 
</div><div id="lc36">|    3597202 | 
</div><div id="lc37">|    3597956 | 
</div><div id="lc38">|    3601494 | 
</div><div id="lc39">|    3601519 | 
</div><div id="lc40">|    3603241 | 
</div><div id="lc41">|    3612015 | 
</div><div id="lc42">|    3612016 | 
</div><div id="lc43">|    3612017 | 
</div><div id="lc44">|    3612018 | 
</div><div id="lc45">|    3613211 | 
</div><div id="lc46">|    3613214 | 
</div><div id="lc47">|    3613220 | 
</div><div id="lc48">|    3613221 | 
</div><div id="lc49">|    3613226 | 
</div><div id="lc50">|    3613228 | 
</div><div id="lc51">|    3613229 | 
</div><div id="lc52">|    3893670 | 
</div><div id="lc53">|    3905287 | 
</div><div id="lc54">|    3919160 | 
</div><div id="lc55">|    3919161 | 
</div><div id="lc56">|    4012917 | 
</div><div id="lc57">+------------+
</div><div id="lc58">52 rows in set (0.01 sec)
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

BBCODE Copy To Clipboarddone!

mysql> select geoname_id from alternames where match(name) against('+copan*' in boolean mode) group by geoname_id order by geoname_id;
+------------+
| geoname_id |
+------------+
|     680926 | 
|     705048 | 
|    1123168 | 
|    1132168 | 
|    1137376 | 
|    1143344 | 
|    1144896 | 
|    1144897 | 
|    1144898 | 
|    1144921 | 
|    1147191 | 
|    1350000 | 
|    1424747 | 
|    1447417 | 
|    1447421 | 
|    1448775 | 
|    1456560 | 
|    1456628 | 
|    1457203 | 
|    1462039 | 
|    1467739 | 
|    1470637 | 
|    1472468 | 
|    1472538 | 
|    1474424 | 
|    1476855 | 
|    3185868 | 
|    3377791 | 
|    3530254 | 
|    3584988 | 
|    3586898 | 
|    3597202 | 
|    3597956 | 
|    3601494 | 
|    3601519 | 
|    3603241 | 
|    3612015 | 
|    3612016 | 
|    3612017 | 
|    3612018 | 
|    3613211 | 
|    3613214 | 
|    3613220 | 
|    3613221 | 
|    3613226 | 
|    3613228 | 
|    3613229 | 
|    3893670 | 
|    3905287 | 
|    3919160 | 
|    3919161 | 
|    4012917 | 
+------------+
52 rows in set (0.01 sec)

--------------------------------------
Colored with http://dumpz.org

Light HTML Copy To Clipboarddone!

That method generates HTML with CSS classes. Hence you'll need the style sheet file

<div class="highlight"><pre><div id="lc1">mysql&gt; select geoname_id from alternames where match(name) against(&#39;+copan*&#39; in boolean mode) group by geoname_id order by geoname_id;
</div><div id="lc2">+------------+
</div><div id="lc3">| geoname_id |
</div><div id="lc4">+------------+
</div><div id="lc5">|     680926 | 
</div><div id="lc6">|     705048 | 
</div><div id="lc7">|    1123168 | 
</div><div id="lc8">|    1132168 | 
</div><div id="lc9">|    1137376 | 
</div><div id="lc10">|    1143344 | 
</div><div id="lc11">|    1144896 | 
</div><div id="lc12">|    1144897 | 
</div><div id="lc13">|    1144898 | 
</div><div id="lc14">|    1144921 | 
</div><div id="lc15">|    1147191 | 
</div><div id="lc16">|    1350000 | 
</div><div id="lc17">|    1424747 | 
</div><div id="lc18">|    1447417 | 
</div><div id="lc19">|    1447421 | 
</div><div id="lc20">|    1448775 | 
</div><div id="lc21">|    1456560 | 
</div><div id="lc22">|    1456628 | 
</div><div id="lc23">|    1457203 | 
</div><div id="lc24">|    1462039 | 
</div><div id="lc25">|    1467739 | 
</div><div id="lc26">|    1470637 | 
</div><div id="lc27">|    1472468 | 
</div><div id="lc28">|    1472538 | 
</div><div id="lc29">|    1474424 | 
</div><div id="lc30">|    1476855 | 
</div><div id="lc31">|    3185868 | 
</div><div id="lc32">|    3377791 | 
</div><div id="lc33">|    3530254 | 
</div><div id="lc34">|    3584988 | 
</div><div id="lc35">|    3586898 | 
</div><div id="lc36">|    3597202 | 
</div><div id="lc37">|    3597956 | 
</div><div id="lc38">|    3601494 | 
</div><div id="lc39">|    3601519 | 
</div><div id="lc40">|    3603241 | 
</div><div id="lc41">|    3612015 | 
</div><div id="lc42">|    3612016 | 
</div><div id="lc43">|    3612017 | 
</div><div id="lc44">|    3612018 | 
</div><div id="lc45">|    3613211 | 
</div><div id="lc46">|    3613214 | 
</div><div id="lc47">|    3613220 | 
</div><div id="lc48">|    3613221 | 
</div><div id="lc49">|    3613226 | 
</div><div id="lc50">|    3613228 | 
</div><div id="lc51">|    3613229 | 
</div><div id="lc52">|    3893670 | 
</div><div id="lc53">|    3905287 | 
</div><div id="lc54">|    3919160 | 
</div><div id="lc55">|    3919161 | 
</div><div id="lc56">|    4012917 | 
</div><div id="lc57">+------------+
</div><div id="lc58">52 rows in set (0.01 sec)
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

Habrahabr.ru HTML Copy To Clipboarddone!

Use that HTML for publications on habrahabr.ru