Thanks for your reply . I am using MySQL with MyISAM tables.
and this my table structure, fields marked red color are need to use in search CREATE TABLE IF NOT EXISTS businesses ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, created date NOT NULL, modified datetime NOT NULL, user_id bigint(20) NOT NULL, slug varchar(255) NOT NULL, `name` varchar(255) NOT NULL, street_name varchar(255) DEFAULT NULL, shopping_center varchar(255) DEFAULT NULL, state_id int(10) NOT NULL, suburb_id int(10) NOT NULL, zip_code varchar(12) DEFAULT NULL, website varchar(250) DEFAULT NULL, email varchar(255) DEFAULT NULL, phone_no varchar(255) NOT NULL, mobile_no varchar(255) DEFAULT NULL, fax varchar(255) DEFAULT NULL, is_active tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; On Wed, Jul 14, 2010 at 7:15 PM, Hugo M <ham1...@gmail.com> wrote: > What DB are you using? > > Often fulltext search is implemented in a DB level (MySQL with MyISAM tabes > and Postgres has this feature built in). > > 2010/7/14 Annamalai <annamala...@gmail.com> > >> Hi >> i am using ordinary search functionality in my business controller . but >> now need to implement FULL TEXT SEARCH. >> can any one give idea ?? Thanks in advance >> >> >> Thanks >> Annamalai.S >> >> Check out the new CakePHP Questions site http://cakeqs.org and help >> others with their CakePHP related questions. >> >> >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To post to this group, send email to cake-php@googlegroups.com >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.com>For >> more options, visit this group at >> http://groups.google.com/group/cake-php?hl=en >> > > Check out the new CakePHP Questions site http://cakeqs.org and help > others with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.com>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
