Nov. 28th, 2015

strredwolf: (CuteFace)
Every *!)@$*( time I go on DA and search for something, I'm pissed off because its NEVER relevant.

For instance, I know there's three breasted artwork on DA.  There's morphs and drawings.  But searching for it is CRAP.  Instead of "three breast" I get "three AND breast" which matches "three ladies from Bombay clad in wool on top of a Taj Ma Hal replica.  Each one points to various gargoyle creatures objecting to how they have an exposed breast."

In other words, how close the words are together is key, and DA ignores it.  I mean, how simple could it be to add that in?!?

Without any knowledge of DA's setup:

SELECT art_id, INSTR(desc, "three")-INSTR(desc,"breast") AS closeness FROM artwork WHERE desc LIKE "%three%" AND desc LIKE "%breast%" ORDER BY closeness;

...relatively easily, if you build a query on the fly.

Profile

strredwolf: (Default)
STrRedWolf

September 2017

S M T W T F S
     12
3 456789
101112 13141516
17181920212223
24252627282930

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 25th, 2017 09:37 am
Powered by Dreamwidth Studios