Sphinx can work and is fairly easy to install. If you don't want that
create a summary temp.
a table has a foreign key to the result row and columns for your search
terms.
On Thu, Oct 21, 2010 at 5:00 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx>wrote:
> I see.
> Thanks for the explanation Bastien.
>
> Best,
> Karl
>
>
> On Oct 21, 2010, at 6:56 AM, Bastien wrote:
>
> FKs are constraints. They really are there to ensure that the data in the
>> FK exists in the other table. They do not operate like a conventional index
>> that is there to aid in selecting data.
>>
>> Bastien Koert
>> 905-904-0334
>> Sent from my iPhone
>>
>> On 2010-10-21, at 7:24 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
>>
>> Excuse me for intruding, but wouldn't this be a Foreign Key solution?
>>> If one field is the same on all tables, can't you just set a Foreign Key
>>> that all tables with that field get their data from?
>>> Then you only have to query the master table??
>>> Or an I not grasping the idea behind Foreign Keys.
>>> I am still learning.
>>> TIA
>>> HTHS
>>>
>>> Karl
>>>
>>> On Oct 21, 2010, at 6:12 AM, Bastien wrote:
>>>
>>> Alternatively, you could try setting that index on each table and use a
>>>> UNION to join multiple queries together provided each query returns the
>>>> identical data set structures ( or the column types have to match)
>>>>
>>>> Bastien Koert
>>>> 905-904-0334
>>>> Sent from my iPhone
>>>>
>>>> On 2010-10-21, at 7:06 AM, Artur Ejsmont <ejsmont.artur@xxxxxxxxx>
>>>> wrote:
>>>>
>>>> I dont think you can create such index across tables.
>>>>>
>>>>> If you are interested read up on sphinx. Im pretty sure you would be
>>>>> able to create what you need.
>>>>>
>>>>> Alternatively ... a super simplistic solution ..... create one extra
>>>>> search table with copy of the data and create index there? ;P hehehe
>>>>> + would let you do what you need
>>>>> - would require a lot more IO to support the extra writes (to keep copy
>>>>> in sync)
>>>>>
>>>>> It would be cool if a fulltext index could be created on a view :)
>>>>>
>>>>> Art
>>>>>
>>>>> On 21 October 2010 09:43, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Is it possible to create one index on multiple tables? I am trying to
>>>>>> create a search function for my web site. The data the user needs to be
>>>>>> able to search is stored in multiple tables. I would like to be able to use
>>>>>> "MATCH / AGAINST", like the query below I found online.
>>>>>>
>>>>>> SELECT firstname, lastname,comments FROM users WHERE
>>>>>> MATCH(firstname,lastname,comments) AGAINST ('$searchterm')
>>>>>>
>>>>>> Ron
>>>>>>
>>>>>
>>>>> --
>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>
>>>>>
>>>> --
>>>> PHP Database Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>>
>>> Karl DeSaulniers
>>> Design Drumm
>>> http://designdrumm.com
>>>
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
