I need a stored procedure that will take a list of comma separated keywords, in order of importance, and compare them to a table of other comma separated lists of keywords, that will ultimately return a specific number of ids from this table. Table example: 01 sports, candy, music 02 politics, music, television 03 computers, politics, music 04 television, candy, computers and when I call the procedure with inputs ["politics,sports,music", 2] I would get back two ids, probably 02 and 01
1) Complete and fully-functional code, ready to insert into mysql as CREATE PROCEDURE statement
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
MYSQL 5.1, and PHP4 (but that shouldn't matter)