I've noticed some people seem to be forgetting about their
middleware when approaching a programming challenge. In many
cases, information to and from the database is processed using C,
java, perl, php, etc. These languages can do pre and post
processing of data. I have found this approach is easier and
sometimes quicker than building a complicated SQL statement.
Since I am familiar with perl and php, I would use regular
expressions either before you issue your insert command or after
the data is selected.
Cheers,
Brian
-----Original Message-----
From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 7:43 AM
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that
cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags,
characters (like
~!@#$%^&*()_+|`-=\{}[]:"<>?;',./ ) out of it, so basically i want
the string
to be just left with words.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_________________________________________________________________
________
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
-----------------------------------------------------------------
----
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
<[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php