Hi all. i would like to have fulltext search in my news site.
I have added fulltext to the text column in my news table. but though it cannot grab two or more phrases at a time from database. the engine is MyISAM. what might be the problem? if possible pls help me. Thanks in advance

Show some test data and the code which you have tried.

first i did like that

ALTER TABLE `chemplist` ADD FULLTEXT (mezmun)

and then

select * from chemplist where mezmun like '%$_GET[q]%'

q is the name of search box
thanks for attention.

I tested MATCH() AGAINST() operator. my code is below
SELECT * , MATCH(qmezmun, mezmun) AGAINST ('AMG Petronas') FROM chemplist

But again it cannot search full text

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.