Posted by Szymon Bobek on 01/27/07 11:01

Hi!

I have databese with a few tables named like that: films_triller,
films_horror, films_action etc.
I decided to create many tables instead of creting just one big table
containing all sort of films. Is it a good idea? (I think, that it boost
search time much - am I right?)
Now - to find a film (when only title is known) I have to search in all
that tables. But I have a problem with that.. How to do that? SELECT * FROM
REGEXP 'film_*' WHERE title='the film' does not work. The same is when I
want to list all tables (to see what groups of films I have) - if I try do
join SHOW TABLES with REGEXP I get an syntax error too.

Where is the mistake and how to correct it?

Thanks in advance
Szymon Bobek

[Back to original message]