Re: String function

2004-11-23 Thread Paul DuBois
At 14:12 -0500 11/23/04, Jerry Swanson wrote: I need to make query that adds numbers. The fields are varchar format so I have some value 12121 and some values 121212,121212. I think I need string replace function that replace comma. What function can do this? It's called REPLACE(). http://dev.mysql

String function

2004-11-23 Thread Jerry Swanson
I need to make query that adds numbers. The fields are varchar format so I have some value 12121 and some values 121212,121212. I think I need string replace function that replace comma. What function can do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Hopefully Easy String Function SQL Question??

2001-11-16 Thread Christopher Oson
Good Day All, Let's say I have a paragraph within a field name [summary] = United States jets reportedly continued bombing targets Thursday in Kandahar, and United States special forces were on the ground coordinating with ethnic Pashtun tr

Reverse of the string function --- SUBSTRING_INDEX

2001-03-17 Thread Redy RAMAMONJISOA
Hi there ! I wanna know if the reverse of the function SUBSTRING_INDEX exists or not. --DESCRIPTION--- == >SUBSTRING_INDEX(str,delim,count) >Returns the substring from string str before count occurrences of the delimiter delim. >If count is positive, everything to the left of the fin