It is frequently faster. Although, not a problem in mysql, msql
frequently ran an order of magnitude faster if the "joins" were done in
perl rather than in the SQL statements.
On Thu, 24 May 2001, Brian Kaney wrote:
> Date: Thu, 24 May 2001 10:01:04 -0400
> From: Brian Kaney <[EMAIL PROTECTED]>
> To: Selvin Sakal <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: characters - URGENT!!
>
> 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
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
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
