Question
Time: 15:22 - Sep 04, 2007 Asked by: ericmichalsen Status: Unanswered Points: 75
How do I favor certain records from an sql query? Such as 50% need to match a certain criteria?
A sample query: SELECT stock_number, log_date, collection, MATCH (description, Keywords) AGAINST ('$query' IN BOOLEAN MODE) AS score FROM media WHERE MATCH (description, Keywords) AGAINST ('$query' IN BOOLEAN MODE) ORDER BY score, log_date DESC LIMIT 0, 20 The kicker is that in the result, 50% need to where collection='TEST_1'
Ask a New Question
Become a Quomon Expert
Current Categories
Other Questions Needing Answers
Question Unanswered
Answer Summary Currently Unavailable.
Respond to this question:
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Enter your email address below and we will resend your login information to you.
Login Information Sent
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
All Questions
Language Options
English:
Español:
Quomon Blog
Sponsors
Questions and Answers Software Real Estate Postcards Marketing Fulfillment