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 Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.