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 Quote Link to comment 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? Quote Link to comment 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 ... Quote Link to comment 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. Quote Link to comment 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.... 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.