aldrin151 Posted October 30, 2008 Share Posted October 30, 2008 Hello, I wanted to see what would be the best way if I was to retrieve values from one field. For example if I have stored Blue, Red, Green, Yellow as it would exactly be stored in the field, and then later be retrieved by search ... example search this field for Blue Green Yellow and sort DESC by the higher number of matches for records... Any suggestions or clues would be greatly appreciate it... thanks Link to comment https://forums.phpfreaks.com/topic/130673-search-or-fetch-multiple-values-stored-in-one-field/ Share on other sites More sharing options...
crochk Posted October 30, 2008 Share Posted October 30, 2008 Is this stored in a database of some sort? Link to comment https://forums.phpfreaks.com/topic/130673-search-or-fetch-multiple-values-stored-in-one-field/#findComment-678101 Share on other sites More sharing options...
aldrin151 Posted October 30, 2008 Author Share Posted October 30, 2008 Yes, I have it stored in mysql db, fld_colors ... Link to comment https://forums.phpfreaks.com/topic/130673-search-or-fetch-multiple-values-stored-in-one-field/#findComment-678102 Share on other sites More sharing options...
crochk Posted October 30, 2008 Share Posted October 30, 2008 MySQL databases do have a built in search function, called "fulltext," I am no fulltext indexing expert and have enough of my own troubles with it, try searching the forums and google for more info. Link to comment https://forums.phpfreaks.com/topic/130673-search-or-fetch-multiple-values-stored-in-one-field/#findComment-678106 Share on other sites More sharing options...
aldrin151 Posted October 30, 2008 Author Share Posted October 30, 2008 Awesome thanks, I will search for it.... Link to comment https://forums.phpfreaks.com/topic/130673-search-or-fetch-multiple-values-stored-in-one-field/#findComment-678111 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.