nepoverljiv Posted October 30, 2011 Share Posted October 30, 2011 How to search 4 columns for one words. I can't with OR because isn't good for my search. I need to look in columns : genres1, genres2, genre3, genres4; are they have on particularly word. Can anyone help me with this? Are can maybe with MATCH? Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/ Share on other sites More sharing options...
AyKay47 Posted October 30, 2011 Share Posted October 30, 2011 mysql_query("SELECT column FROM table WHERE MATCH('column1','column2','column3','column4') AGAINST ('keyword')"); http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/#findComment-1283460 Share on other sites More sharing options...
nepoverljiv Posted October 30, 2011 Author Share Posted October 30, 2011 Not work. I try $proba = mysql_query("SELECT column FROM filmovi WHERE MATCH('genres1','genres2','genres3','genres4') AGAINST ('Action')"); What can be problem, and what SELECT column FROM means? Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/#findComment-1283467 Share on other sites More sharing options...
AyKay47 Posted October 30, 2011 Share Posted October 30, 2011 insert the correct column names that you want to grab where i put "column" Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/#findComment-1283469 Share on other sites More sharing options...
nepoverljiv Posted October 30, 2011 Author Share Posted October 30, 2011 But I don't have just one column, I have 4. How to write right name when I have 4 name. How to which name is right? Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/#findComment-1283470 Share on other sites More sharing options...
fenway Posted October 31, 2011 Share Posted October 31, 2011 Again, read the link provided -- make a fulltext index that spans all 4 columns. Link to comment https://forums.phpfreaks.com/topic/250115-search-four-columns-in-one-query/#findComment-1283832 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.