MySQL joined select

[Marek]

Thanks a lot! That helped me a lot man.

Marek Reichenbach

On 2012 Kov. 19, at 19:29, Ken Ray <kray at sonsothunder.com> wrote:

> 
> On Mar 19, 2012, at 3:44 AM, Marek Reichenbach wrote:
>> when i get for example: 1234567 -> i should get result +++++++, 123-56-  I
>> would get +++-++- .
> 
> The only way I know is kind of ugly, requiring seven nested REPLACE statements:
> 
> SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("123-56-","1","+"),"2","+"),"3","+"),"4","+"),"5","+"),"6","+"),"7","+")
> 
> This would return:
> 
> +++-++-
> 
> 
> Ken Ray
> Sons of Thunder Software, Inc.
> Email: kray at sonsothunder.com
> Web Site: http://www.sonsothunder.com/    
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode