Destramic Posted January 30, 2011 Share Posted January 30, 2011 hey im trying to seach a table and all columns rows to match a query string...what is the best way to do this please? thanks Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/ Share on other sites More sharing options...
QuickOldCar Posted January 31, 2011 Share Posted January 31, 2011 This is the best reference I can give you. http://dev.mysql.com/doc/refman/5.5/en/optimization-indexes.html Indexing the tables makes searches much faster. EXPLAIN http://dev.mysql.com/doc/refman/5.5/en/explain.html I feel MATCH AGAINST or even full text indexing also in booleon mode is much faster than LIKE when comes to searches. Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1167576 Share on other sites More sharing options...
Destramic Posted January 31, 2011 Author Share Posted January 31, 2011 erm ok so what would my news table query look like if i wanted to search the `news` columns for a word? Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1167991 Share on other sites More sharing options...
Maq Posted January 31, 2011 Share Posted January 31, 2011 erm ok so what would my news table query look like if i wanted to search the `news` columns for a word? Check out the links QuickOldCar provided, there are plenty of examples. Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1168071 Share on other sites More sharing options...
ManiacDan Posted January 31, 2011 Share Posted January 31, 2011 MySQL's full-text searching feature may be of interest to you. Warning, it's very complicated. If you need to be told how to set up your table for a simple LIKE match, match...against will be beyond your skill level at the moment. Bookmark the URL though. -Dan Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1168089 Share on other sites More sharing options...
Destramic Posted February 1, 2011 Author Share Posted February 1, 2011 Thanks for your posts And dan I think full text search is what I need but how do I reach the columns that are not full text? Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1168256 Share on other sites More sharing options...
ManiacDan Posted February 1, 2011 Share Posted February 1, 2011 how do I reach the columns that are not full text? Make them full text if you want to search them. If you want to simply SELECT the ones that aren't fulltext, fulltext matching works on the WHERE condition. You can easily say: SELECT id, name FROM products WHERE MATCH(description) AGAINST('dog') -Dan Link to comment https://forums.phpfreaks.com/topic/226162-seaching-like/#findComment-1168333 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.