Untitled

CREATE OR REPLACE VIEW `societe_propriete_vue` AS SELECT id_societe_propriete,propriete.propriete,IF( `societe_propriete`.valeur REGEXP 'm$', REPLACE( `societe_propriete`.valeur, 'm', '' ),REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(		REPLACE(REPLACE(REPLACE(REPLACE(`societe_propriete`.valeur		,'M','')		,'O','0')		,'..','.')		,'(','5')		,'ç','9')		,'à','0')		,'?','.')		,'0 à ','')		,'~','')		,'m','.')		,'+','')		,'-','')		,';','.')		,',','.')		,' ,','.')		) as valeur	FROM `societe_propriete`INNER JOIN propriete ON propriete.id_propriete =societe_propriete.id_propriete WHERE propriete.type ='distance'AND `societe_propriete`.`valeur` != ''AND propriete.id_composant=3GROUP BY `societe_propriete`.`valeur`ORDER BY propriete.propriete, `societe_propriete`.`valeur`;