I just can't figure out how to loop trough all tables on my site. I have following tables I would like to search:

breeds:----id---breed---description
stories:----id---title---story
behavior:--id---title---text

First column contain names of the tables, rest are row names, I hope the structure is clear. (don't know if this is important, there are more fields in this tables but I need to search only mentioned rows). All tables are independent, means they are not in any relation by id value.

Can someone help me with query which would make this possible? I've read about UNION but don't know to implement it.

Thanks!