strredwolf: (CuteFace)
[personal profile] strredwolf
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.
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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:38 am
Powered by Dreamwidth Studios