'Union error in one select but I still want the results

I am doing a large union select and all of the union selects will retrieve a result except for one. One of them has a collation error. For example

SELECT word FROM words WHERE english = 'hello'
UNION
SELECT word FROM words WHERE english = 'no'
UNION
SELECT word FROM words WHERE english = 'пыук';

The last one would produce a collation error and therefore the whole select fails. Is there a way that I can include the select for the one that will return the error while still getting the results for the rest of them?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Union error in one select but I still want the results

Sources

Related Questions