Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

mysql001, Update part of string which contains int numbers

Language: Layout:
absolute service time: 0,35 sec 
edit mode |  history 
  
CONCAT(
LEFT(s, INSTR(s,'9')-1)             
,'0',
RIGHT(s,CHAR_LENGTH(s)-1- CHAR_LENGTH(LEFT(s, INSTR(s,'9')-1)))
)



1
0 0 0 6 7 2 6 8 6 1 7 5 3 2 4 0 9 4






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development