Table fields for "friends" ... more of a MySQL Question

[eluser]rweston[/eluser]
[quote author="Josh Giese" date="1204726028"]I have a social network with friendships. One table, using the union method works great for me.[/quote]

I should have been clear. For this application, the Union VS OR probably doesnt make a big difference, but i tried SELECT A,B,C FROM Table1 WHERE A Like 'XY%';

where Table1 was a View which was a union of 2 base tables and of course, what was expected was that the underlying indices were to have been used, but that did not seem to be the case.