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
azegurb 1 Posting Whiz in Training
smantscheff 265 Veteran Poster
Show some test data and the code which you have tried.
azegurb 1 Posting Whiz in Training
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.
smantscheff 265 Veteran Poster
- You don't need a fulltext index for queries with the LIKE operator. To make use of the fulltext index, use the MATCH operator (http://dev.mysql.com/doc/refman/5.5/en//fulltext-search.html).
- Your code is prone to SQL insertion. Make sure that $_GET[q] contains what you expect.
azegurb 1 Posting Whiz in Training
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.