SELECT
--  ia.Email
  REPLACE(concat_ws(' ',ia.First_Name,ia.Last_Name),' ','')
FROM
  (SELECT
	 Last_Name,
	 First_Name,
	 Email
  FROM Contributor ia
  WHERE Email IS NOT NULL
UNION
  SELECT
	 name,
	 first_Name,
	 Email
  FROM Person
  WHERE Email IS NOT NULL) ia
WHERE REPLACE(concat_ws(' ',ia.First_Name,ia.Last_Name),' ','') = REPLACE('André Van Ryckeghem',' ','') collate latin1_general_ci;


SELECT concat_ws(' ',ia.First_Name,ia.Last_Name)
FROM Contributor
WHERE ia.First_Name = 'André Van';

-- WHERE REPLACE(concat_ws(' ',ia.First_Name,ia.Last_Name),' ','#') = REPLACE('André Van Ryckeghem',' ','#');

-- WHERE ia.First_Name = 'André Van';

-- WHERE concat_ws(' ',ia.First_Name,ia.Last_Name) LIKE 'André Van Ryckeghem' COLLATE latin1_swedish_ci;

-- WHERE concat_ws(' ',ia.First_Name,ia.Last_Name) = CONVERT('André Van Ryckeghem' USING latin1);

-- WHERE ia.Last_Name = 'Ryckeghem';

-- WHERE concat_ws(' ',ia.First_Name,ia.Last_Name) = 'André van Ryckeghem';

-- WHERE ia.Last_Name = 'Ryckeghem';

-- 


-- WHERE concat_ws(' ',ia.First_Name),ia.Last_Name) = CONVERT('André Van Ryckeghem' USING utf8);

-- SELECT *
-- FROM `Person`
-- WHERE `first_name` LIKE CONVERT( _utf8 'André'
-- USING latin1 )
-- COLLATE latin1_swedish_ci
-- LIMIT 0 , 30