Re: Searching in text or blob field

check out http://www.hansanderson.com/php/, I have a search tool there. On Fri, 14 Jul 2000, 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. > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > Hans Anderson ~ me@hansanderson.com PO Box 426, Missoula, MT 59806 | PHP, Search Engines, SQL (800)397-9116 / (406)549-6524 | Databases, Flash Multimedia, http://www.hansanderson.com | Killer Audio Production, http://www.goofiness.com | Minty Fresh Breath.