how to implement color search with sphinx?

Posted by harald on Stack Overflow See other posts from Stack Overflow or by harald
Published on 2010-09-23T08:31:10Z Indexed on 2010/12/25 8:54 UTC
Read the original article Hit count: 346

Filed under:
|
|
|

hello,

searching a photo by dominant colors using mysql is quite simple. assuming that the r,g,b values of the most dominant colors of the photo is already stored in the database, this could be achieved for example by something like:

SELECT * FROM colors
WHERE    ABS(dominant_r - :r) < :threshold
AND      ABS(dominant_g - :g) < :threshold
AND      ABS(dominant_b - :b) < :threshold

i wonder, if it's anyhow possible to store the colors in sphinx and perform the querying using the sphinx search engine?

thanks!

© Stack Overflow or respective owner

Related posts about search

Related posts about colors