<div>
what about:<br />

<pre><code class="code-1 nolinks" id="code-123801"><span>delete yourtable</span>
<span>where email like '%support%'</span>
<span>   or email like '%info%'</span>
<span>   or email like '%admin%' </span>
<span></span>
<span>you might want to use a SELECT first to avoid any surprises later :)</span>
</code></pre>
</div>


<div>
So will this delete the Table or just the record?<br />
I just want to delete the record.
</div>


<div>
Basically,<br />
<br />
Delete * from myTable where email like 'support%'<br />
&nbsp; &nbsp;or email like 'info%'<br />
&nbsp; &nbsp;or email like 'admin%'
</div>


<div>
%support% &lt;-- not right<br />
support% &nbsp; &nbsp; &lt;-- right
</div>


<div>
Quick question, is there anyway to do this in reverse?<br />
<br />
select * from table except those Like options?
</div>


<div>
In the code snippet, the SELECT might do the trick, but [caveat] I can't test it right now [/caveat].<br />
<br />
Reference: <a href="http://www.htmlite.com/mysql011.php" rel="ugc">http://www.htmlite.com/mysql011.php</a>&nbsp;and note the use of underscore vs percent.<br />
<br />
The second part is the way I would code the DELETE<br />
<br />
HTH, ~Ray<br />

<pre><code class="code-1 nolinks" id="code-123919"><span>SELECT * FROM myTable WHERE email NOT LIKE \&quot;support%\&quot; </span>
<span> </span>
<span> </span>
<span>DELETE * FROM myTable WHERE email LIKE 'support%' OR email LIKE 'info%'</span>
<span> Etc... </span>
</code></pre>
</div>


<div>
&gt;Quick question, is there anyway to do this in reverse?<br />
yes:<br />

<pre><code class="code-1 nolinks" id="code-124005"><span>select *</span>
<span>from yourtable</span>
<span>where NOT (email like 'support%'</span>
<span>   or email like 'info%'</span>
<span>   or email like 'admin%' </span>
<span>    )</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have a database full of email addresses.<br />
I have this in my database:<br />
<br />
support@xyz.com<br />
info@sss.com<br />
admin@tyum.com<br />
sam@good-email.com<br />
<br />
I want to seach for any words : support, info,or admin, in the database and if found, delete the whole record.<br />
Is there a way to do this
</div>
</div>


I have a database full of email addresses.
I have this in my database:

support@xyz.com
info@sss.com
admin@tyum.com
sam@good-email.com

I want to seach for any words : support, info,or admin, in the database and if found, delete the whole record.
Is there a way to do this

delete out data with certains prefixes

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.