snipt

Ctrl+h for KB shortcuts

Text only

My list

[]
https://snipt.net/embed/8c984b57430af21435800895dfed60b6/
/raw/8c984b57430af21435800895dfed60b6/
8c984b57430af21435800895dfed60b6
text
Text only
1
2019-08-23T16:40:37
True
False
False
/api/public/snipt/203642/
my-list-d19acb37
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>[] </span></pre></div> </td></tr></table>

MySQL

find rows containing letters, numbers or special characters

1
2
3
4
-- find rows containing letters, numbers or special characters;
SELECT * FROM your_table WHERE your_column REGEXP '[A-Za-z]';		-- find rows containing letters;
SELECT * FROM your_table WHERE your_column REGEXP '[0-9]';		-- find rows containing numbers; 
SELECT * FROM your_table WHERE your_column REGEXP '[^a-zA-Z0-9]';	-- find rows containing special characters;
https://snipt.net/embed/04112401e44c91be5bada65a2e20a234/
/raw/04112401e44c91be5bada65a2e20a234/
04112401e44c91be5bada65a2e20a234
mysql
MySQL
4
2019-08-19T12:56:26
True
False
False
Jul 23, 2019 at 09:51 AM
/api/public/snipt/184318/
find-rows-containing-letters-numbers-or-special-characters
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">-- find rows containing letters, numbers or special characters;</span> </span><span id="L-2"><a name="L-2"></a><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">your_table</span> <span class="k">WHERE</span> <span class="n">your_column</span> <span class="k">REGEXP</span> <span class="s1">&#39;[A-Za-z]&#39;</span><span class="p">;</span> <span class="c1">-- find rows containing letters;</span> </span><span id="L-3"><a name="L-3"></a><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">your_table</span> <span class="k">WHERE</span> <span class="n">your_column</span> <span class="k">REGEXP</span> <span class="s1">&#39;[0-9]&#39;</span><span class="p">;</span> <span class="c1">-- find rows containing numbers; </span> </span><span id="L-4"><a name="L-4"></a><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">your_table</span> <span class="k">WHERE</span> <span class="n">your_column</span> <span class="k">REGEXP</span> <span class="s1">&#39;[^a-zA-Z0-9]&#39;</span><span class="p">;</span> <span class="c1">-- find rows containing special characters;</span> </span></pre></div> </td></tr></table>
search

Text only

My list

[]
https://snipt.net/embed/1cc5396c5b1e721ec24a1abe858c3be9/
/raw/1cc5396c5b1e721ec24a1abe858c3be9/
1cc5396c5b1e721ec24a1abe858c3be9
text
Text only
1
2019-08-19T12:57:20
True
False
False
/api/public/snipt/183887/
my-list-f21a0820
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>[] </span></pre></div> </td></tr></table>

Text only

bridal makeup in bangalore

GlossNGlass is a Top Makeup Studio & Academy in bangalore. We have best bridal makeup in bangalore with price ✓Professional Makeup artists in Bangalore ✓ Bridal makeup in Bangalore ✓Makeup Courses in Bangalore Best Prices
Visit: https://www.glossnglass.com
https://snipt.net/embed/9fcdc3c990db3f7729425b8fb8e0d71c/
/raw/9fcdc3c990db3f7729425b8fb8e0d71c/
9fcdc3c990db3f7729425b8fb8e0d71c
text
Text only
3
2019-07-22T06:25:20
True
False
True
Jul 22, 2019 at 06:23 AM
/api/public/snipt/182856/
bridal-makeup-in-bangalore
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>GlossNGlass is a Top Makeup Studio &amp; Academy in bangalore. We have best bridal makeup in bangalore with price ✓Professional Makeup artists in Bangalore ✓ Bridal makeup in Bangalore ✓Makeup Courses in Bangalore Best Prices </span><span id="L-2"><a name="L-2"></a>Visit: https://www.glossnglass.com </span></pre></div> </td></tr></table>

Markdown

health management course in bangalore | jumpmasterlearn

Personality development training in bangalore, the best soft skills training centre to develop your body language, personal ability. and also we provides health management and sales training.<a href="https://www.jumpmasterlearning.com/">health management course in bangalore </a>

https://snipt.net/embed/1e58c789e3e9f48dee5f4e8a527fe8bc/
/raw/1e58c789e3e9f48dee5f4e8a527fe8bc/
1e58c789e3e9f48dee5f4e8a527fe8bc
markdown
Markdown
1
2019-07-22T06:20:40
True
False
True
Jul 22, 2019 at 06:15 AM
/api/public/snipt/182842/
health-management-course-in-bangalore-jumpmasterlearn
<p>Personality development training in bangalore, the best soft skills training centre to develop your body language, personal ability. and also we provides health management and sales training.&lt;a href="https://www.jumpmasterlearning.com/"&gt;health management course in bangalore &lt;/a&gt;</p>
course, health, managemnet

Text only

Untitled

lel
https://snipt.net/embed/27cafff4ccc7264b746e3285823ecb11/
/raw/27cafff4ccc7264b746e3285823ecb11/
27cafff4ccc7264b746e3285823ecb11
text
Text only
1
2019-08-19T13:01:44
True
False
False
Jul 21, 2019 at 01:08 PM
/api/public/snipt/181304/
9986cda1
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>lel </span></pre></div> </td></tr></table>

Text only

My list

[]
https://snipt.net/embed/103dfe52037cabc2398396998949d692/
/raw/103dfe52037cabc2398396998949d692/
103dfe52037cabc2398396998949d692
text
Text only
1
2019-08-19T13:02:14
True
False
False
/api/public/snipt/181059/
my-list-a3d44b24
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>[] </span></pre></div> </td></tr></table>