Re: Searching in text or blob field

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.