RE: String Functions

2003-12-04 Thread Victor Pendleton
-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

RE: String Functions

2003-12-04 Thread Luc Foisy
Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:15 AM To: Luc Foisy; MYSQL-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, Dece

RE: String Functions

2003-12-04 Thread Victor Pendleton
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? Such

Re: String functions for GROUP BY clause

2003-11-12 Thread Diana Soares
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

Re: String functions for use in GROUP clause?

2003-10-10 Thread Egor Egorov
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? > > SELE

Re: String Functions and Date Format Living Together in Harmony?

2002-09-20 Thread Paul DuBois
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.