Thanks for your reply. To be more specific, would it make sense to do this portion of the tutorial?
Setup So to get things started, we need to download seachable behavior from ( http://code.google.com/p/searchable-behaviour-for-cakephp). Then we copy the archive contents to the /app folder. To complete the installation process there is one more thing to do: create the search table. So we run the following sql code: CREATE TABLE `search_index` ( `id` int(11) NOT NULL auto_increment, `association_key` int(11) NOT NULL, `model` varchar(128) collate utf8_unicode_ci NOT NULL, `data` longtext collate utf8_unicode_ci NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL, PRIMARY KEY (`id`), KEY `association_key` (`association_key`,`model`), FULLTEXT KEY `data` (`data`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; On Tue, Oct 18, 2011 at 2:45 PM, Dee Johnson <devario...@gmail.com> wrote: > If I understand correctly you want to search for a literal 'Smith' and not > any %Smith% which yeilds results containing Smith as well? If you have a > column for last name already you can just alter your find query in the > controller to only bring back that specific item > > $this->Model->find('all', array('conditions' => array('Model.lastname' => > $searchterm))); > as opposed to > $this->Model->find('all', array('conditions' => array('Model.lastname > LIKE' => '%' . $searchterm . '%'))); > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > 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 > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. 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
