i have table with details of item number part number, manufacturer,
description etc., and i am allowing user to search by entering the part
number, basically part numbers starts with 1N500 in case any user enters
5001N still the search priority should begins with 1N then its next
priority should be contains with. i have tried this it works correctly in
case i entered 1N500 here is the code. can anyone help me out how do i need
to prioritized the query that should always being 1N in case any user 5001N
? Thanks
SELECT * FROM dist WHERE MATCH('"^1N500*"') LIMIT 0,25
OPTION
FIELD_WEIGHTS=(SKEY=10000,PART_NUMBER=9000,ALTERNATE_PART_NUMBER=3000,SHORT_DESCRIPTION=75,LONG_DESCRIPTION=25,INTERNAL_NUMBER=5),
RANKER = PROXIMITY_BM25, MAX_MATCHES=25; SHOW META LIKE 'total%';
--
You received this message because you are subscribed to the Google Groups
"sphinx-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sphinx-users.
For more options, visit https://groups.google.com/d/optout.
