Searching in text or blob field
| From: | php | Date: | Fri, 14 Jul 2000 12:29:54 +0000 |
| Subject: | Searching in text or blob field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1145@lists.php.net to get a copy of this message | ||
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.