Delete tables with non-latin characters

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,197 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,219 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 273 | Replies: 1

•

Join Date: Feb 2008

Posts: 5

Reputation: vaibhavs is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

vaibhavs

Offline

Newbie Poster

Delete tables with non-latin characters

Mar 2nd, 2008

Hi,

I am using Cerberus ticketing system

Recently I have started getting lots of junk email with the subject line containing non0latin characters.
The Subject & Content looks like this:

Help with Code Tags

(Toggle Plain Text)

<br>
antivirus Äú=ºÃ£º<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;ÖÐ¹úÉÌÒµÊý¾Ý¿ª·¢×éÖ¯ÎªÄúÌá¹©±ãÀû¶øÇ¿¾¢µÄ£¬<br />
¡ï£µ£°£°£°£°£°£°ÖÁ¡ï£µ£°£°£°£°£°£°£°ÉÌÎñµç×ÓÐÅ<br />
º¯±¬·¢Í¶·Å·þÎñ£¬È·±£ÄúµÄ²úÆ·(ºÍ·þÎñ)µÃµ½¼«´óÊý<br />
Á¿Ïû·ÑÕßµÄ¹Ø×¢ÓëÇàíù£¬²»³îÄúµÄÉúÒâÃ»ÓÐ×ª»ú£¬´ø<br />
À´È«ÐÂÈ«·½Î»´ó¸²¸ÇÂÊµÄÉÌ»ú£¬Ç§Íò¼¶µÄÊÐ³¡ÄúÒ²ÄÜ<br />
Ó®µÃ£¬Ê÷Æ·ÅÆ´òÊÐ³¡µÚÒ»Ñ¡Ôñ£¡<br />
<br />
½ñÌìÄú·¢ÁËÂð£¿Èç¹û»¹Ã»ÓÐ£¬ÇëÝ°ÁÙ£º<br />

Is there any way I can run a script which will find rows with such characters and delete the rows.

I tried searching on google for any way to detect non-english chatacters, but no help.

Looking for some tips.

Thx
Vai