|| allows you to stick two or more strings together.
This operation is concatenation.
s1 || s2
In this example you put the region and the name together for each country.
In MySQL the || is used for logical OR.
SELECT region || name FROM bbc