|
|
Posted by Paul Lautman on 01/27/07 15:17
Norman Peelman wrote:
> Szymon Bobek wrote:
>> 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
>>
>>
>
> Your structure is fine... the problem is your method of searching. I'm
> not really sure you can use REGEX in that context:
You REALLY think that structure is fine???
Navigation:
[Reply to this message]
|