SELECT id,numeroBeneficiaire,telephonePortable,telephoneAppMobile,emailBeneficiaire 
FROM  beneficiaire   
WHERE (telephonePortable IS NOT NULL OR telephonePortable !='')
AND telephonePortable NOT LIKE '255%'


SELECT id,numeroBeneficiaire,telephonePortable,telephoneAppMobile,emailBeneficiaire 
FROM  beneficiaire   
WHERE telephonePortable='225'




UPDATE  
 beneficiaire SET  telephonePortable =REPLACE (telephonePortable,'225225','225')
WHERE id IN (15925)

SELECT   telephonePortable
FROM beneficiaire  
WHERE id IN (15925)




UPDATE  
 beneficiaire SET  telephonePortable =''
WHERE WHERE telephonePortable='225'

UPDATE  
 beneficiaire SET  telephoneAppMobile ='',emailBeneficiaire=''
WHERE id IN (626)



UPDATE  
 beneficiaire SET  telephonePortable =REPLACE (telephonePortable,'225225','225')
WHERE id IN (15924)



-- 2250708812891,2250544252625