Re: [PHP-DB] Searching in text or blob field From: Michael Dearman (mdearman <email protected>)
Date: 07/14/00

php wrote:
>
> Hi there
> I try to create a dynamic content webpage with mysql.
> I store my content in database like this
> ------------------------------------------------------------------------
> Field id | topic | Content |
> date
> ------------------------------------------------------------------------
> type | int varchar text or blob date
> written
>
> and I need a search engine inside my webpage .
> I can search by topic but I need a search by content too.
> I think it's not good idead to seach like search topic because
> it 's a large field.
> It can solve my ploblem if I use index table to store keyword
> and id of my content like this ID | Keyword
> but English is not use in my content .Asian lang. is not support
> method to find keyword and keep it in to index table
> So, anyone have anthor method to solve this ploblem ?
>
> Thanks
> Tongdee
>
> Sorry for my ugly English.

Hi Tongdee,

The English is fine.

Warning: Novice here, so ....

Take a look at indexing your text or blob fields(directly). Can do that from
v3.23.2 and on. You set a prefix size to limit the size of the index. Don't
know the details.

(note: You might want to read up on fragmentaion problems with
       text/blob fields and the 'optimize table' command,
       if you haven't already. At least I think that's important
       when using indexes on text/blob fields)

But, you do want to use an English keyword to reference an Asian Lang text field?

>From what I'm reading, your approach is the common way to address this problem.

Or
 - match your English keyword with a corresponding Asian keyword
 - use the Asian keyword for the actual search into the indexed Asian text

Or am I missing more than I usually do. In that case, maybe
a more informed list member could help us both out. ;-)

Mike D. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>