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

[eluser]rweston[/eluser]
[quote author="webthink" date="1204729489"]It seems we're losing sight of the issue a bit but rweston, I seem to remember something to do with LIKE statements not being able to use indicies. You might want to look into that.
Either way I think for jonnyjon's case the OR solution I provided above is probably the best way to go. That is after all what OR was designed for. UNIONS are typically used to join 2 tables of unrelated data which isn't really what we're dealing with here.[/quote]

[thumbs up], but when using the same queries against the base table, the query time was acceptable vs use against the view. Anyway, good point though; maybe i should start my own thread about the experience.

[quote author="jonnyjon" date="1204747782"]Thanks for all the great replies guys. Good to hear I can use only 1 record per association.[/quote]

[thumbs up]