Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function to strip non numeric characters from a string?
-List (E-mail)
Subject: RE: String Functions
Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function
-List (E-mail)
Subject: RE: String Functions
That I can do
REPLACE(REPLACE(REPLACE(REPLACE(str,'(',''),')',''),'-',''),' ','')
Looks kinda horrid to handle removing just four characters ( ) - and space
And if any other characters end up in str, then they are not handled, and my
formula is broken.
So
If you're using MySQL 4.1, you have the GROUP_CONCAT(expr) function.
If not, then... i think someone has already done an UDF about this...
Search the archives..or see this:
http://www.cwts.nl/buter/misc/my-mysql.html
--
Diana Soares
On Wed, 2003-11-12 at 08:56, Ciprian Trofin wrote:
Is there
David Garamond [EMAIL PROTECTED] wrote:
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT
At 12:39 -0400 9/20/02, Stanley, Jason wrote:
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure
how to handle the syntax with two sets of parentheses.
The