Hi
I've just read your job description carefully.
I have specialized in MySQL since 2004 and have strong experiences in MySQL query.
I am introducing my query that I made past time and want to show you if it is satisfied you.
SELECT id, GROUP_CONCAT(res SEPARATOR ' ' ) AS result FROM
(SELECT id, field1, lowcase, CONCAT(UPPER(SUBSTR(lowcase,1,1)),SUBSTR(lowcase,2, LENGTH(lowcase)-1)) res
FROM(
SELECT
id,
SUBSTRING_INDEX(
SUBSTRING_INDEX(field1, ' ', n),
' ',
-1
) AS field1,
LOWER(SUBSTRING_INDEX(
SUBSTRING_INDEX(field1, ' ', n),
' ',
-1
)) lowcase
FROM tablea
JOIN (SELECT 1 AS n
UNION SELECT 2 AS n
UNION SELECT 3 AS n
UNION SELECT 4 AS n
UNION SELECT 5 AS n
UNION SELECT 6 AS n
UNION SELECT 7 AS n
UNION SELECT 8 AS n
UNION SELECT 9 AS n
UNION SELECT 10 AS n) numbers
ON CHAR_LENGTH(field1)
- CHAR_LENGTH(REPLACE(field1, ' ', ''))
>= n - 1) tbl
ORDER BY id
) tblB
GROUP BY id