Yes, the Opera mobile browser does open MySpace, Facebook and other social media websites.
The functionality is restricted if you visit the standard site but on the Sony Ericsson P1i and other mobile browsers a ‘mobile friendly’ version of the site is available allowing easy navigation of the site.