Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottie35s
Starting Member
2 Posts |
 Posted - 2013-02-06 : 11:36:48
|
| Hi, the basic search on my site is too specific.. Meaning it's too exact with word order and phrases.For example, if I search Shoes Red it won't show results for Red Shoes.If you search for Red Shoe Laces it won't show results for Red Laces (as the word shoe throws off this order). Below is the code that I believe the search box is using. Can anyone tell me how to "loosen" up this search so it's either more broad or so exact word order isn't necessary?This is the current code:case 'search': if (intval($filter) != 0) { $filter = JString::strtolower($filter); $id = intval($filter); $search .= $temp."(a.id = $id OR LOWER(a.ad_headline) LIKE '%".$this->_db->getEscaped($filter,true)."%' OR LOWER(a.ad_text) LIKE '%".$this->_db->getEscaped($filter,true)."%')"; } else { $filter = JString::strtolower($filter); $search .= $temp."(LOWER(a.ad_headline) LIKE '%".$this->_db->getEscaped($filter,true)."%' OR LOWER(a.ad_text) LIKE '%".$this->_db->getEscaped($filter,true)."%')"; } break; } } } return $search; }Any ideas here? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-06 : 11:40:17
|
| sounds like full text search to me------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
scottie35s
Starting Member
2 Posts |
Posted - 2013-02-06 : 12:08:52
|
| How do I fix this code though? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Need Help With SQL Code For Basic Search