Hi there,
can anyone suggest how this query could have relevancy ordering put into it?
SELECT DISTINCT images.* FROM images
LEFT JOIN imagekeyword ON images.imageid=imagekeyword.imageid
LEFT JOIN imageformat ON images.imageid=imageformat.imageid
LEFT JOIN imagelocation ON images.imageid=imagelocation.imageid
LEFT JOIN imagecategory ON images.imageid=imagecategory.imageid
WHERE ( MATCH (images.title) AGAINST ('cat dog') OR imagekeyword.keyword
= 'cat' OR imagekeyword.keyword = 'dog' OR images.imageid = 'cat' OR
images.imageid = 'dog')
AND (imageformat.format = 'Collage' OR imageformat.format = 'Landscape')
AND (imagecategory.category = 'Animals' OR imagecategory.category = 'Plant
Life')
AND (imagelocation.location = 'Australia' OR imagelocation.location = 'France')
I'd like some kind of relevancy on images.title and imagekeyword.keyword
Thanks for any help you can offer,
cheers - dunstan
---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
