T
T
tigra2018-04-23 18:17:52
Sphinx
tigra, 2018-04-23 18:17:52

Why doesn't Sphinx search by percent sign?

SELECT * FROM `ads` WHERE (MATCH('@name \"*99%*\"'))

the selection includes records
PS3 super slim 99% new (ok)
....
Toyota Raum 1999 (NOT ok)
Mitsubishi Pajero 1996 (NOT ok)
how to make a query so that it finds only those records that specifically contain "99%" ? it's not like a special character, escaping doesn't work either(
SELECT * FROM `ads` WHERE (MATCH('@name \"*99\\%*\"'))

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dimonchik, 2018-04-23
@tigroid3

https://stackoverflow.com/questions/8678989/how-ca...
sphinxsearch.com/forum/view.html?id=3984

P
Puma Thailand, 2018-04-24
@opium

Change search mode to full match, add percentage to indexed characters

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question