a SQL dialect that enables Sphinx search functionality in a standard SQL syntax.
Questions tagged [sphinxql]
120 questions
0
votes
2 answers
Select most similar values in Sphinx index and order them by similarity
I need Sphinx to give me partial/incomplete matches, like if a word has been misspelled in the search. My goal is to find the most similar string in my index.
My index has id, and name, which consists of a string (between 1 and 4 words).
For…
Jeff B.
- 1,117
- 3
- 16
- 40
0
votes
1 answer
SphinxQL request similar to LIKE in SQL
I was wondered I got the different results of the following requests:
SphinxQL:
SELECT ticket_id FROM message WHERE MATCH('*test*') LIMIT 0, 100000 OPTION max_matches = 100000
Result was 221 rows
SQL:
SELECT * FROM `ticket_logs` WHERE message LIKE…
Paul Basenko
- 895
- 1
- 9
- 22
0
votes
0 answers
MySQL: Multiple values search within aggregated string
If I have such as table below
|---col_1---|---col_2-----|
|---19------| "A; E; C; H"|
|---23------| "B; E; C" |
|---24------| "O; D" |
where col_2 is GROUP_CONCATed (by semicolon) column and I'm passing "E; A; C", I want to SELECT 19, 23…
Novitoll
- 820
- 1
- 9
- 22
0
votes
1 answer
SphinxQL Variables Deprecated, Alternate Query?
I had what I thought was a fairly straightforward SphinxQL query, but it turns out @ variables are deprecated (see example below)
SELECT *,@weight AS m FROM test1 WHERE MATCH('tennis') ORDER BY m DESC LIMIT 0,1000 OPTION ranker=bm25,…
user2648990
- 103
- 1
- 6
0
votes
1 answer
Does sphinxql support 'not between'?
I tried
SELECT count(*) as count FROM rt_item WHERE MATCH('') AND sale between 1 and 2;
and got many rows.
But sphinx complains
ERROR 1064 (42000): sphinxql: syntax error, unexpected BETWEEN, expecting IN near 'between 1 and 2'
when I…
chariothy
- 320
- 2
- 8
0
votes
0 answers
Slash or Space in sphinxql in a faucet field does not work
I have a query like this:
select id from myindex
where match('main search keywords') and
myfilter in ('somevalue')
order by weight() desc limit 0,50
option max_matches=5000 facet myfilter limit 5000
And the sphinx conf has this attribute…
Imran Ahmed
- 790
- 1
- 9
- 22
0
votes
2 answers
Sphinx wildcard match on realtime index
I have created realtime index:
index berni_filter2
{
rt_mem_limit = 512M
type = rt
path = /var/lib/sphinxsearch/data/berni_filter
rt_attr_uint = product_id
rt_attr_uint = store_id
rt_field …
gvozd1989
- 300
- 1
- 16
0
votes
1 answer
Using custom variables in Sphinx queries
I need execute 2 queries by one queue and passing result of first query to IF expression of other query as well as ordinary MySQL queries.
As example, I try pass @average variable into second query:
SET @average=(SELECT AVG(weight()) avg_rank FROM…
Daniyal
- 129
- 2
- 9
0
votes
0 answers
SphinxQL Facet returns no more than 1000 results
I have an sphinx index and I query via sphinx QL with facets...
This is my sphinx ql query:
SELECT ID FROM index_search WHERE MATCH('refrigerator') ORDER BY WEIGHT() DESC LIMIT 0,20
OPTION max_matches=5000
FACET CATEGORY_ID
FACET…
Imran Ahmed
- 790
- 1
- 9
- 22
0
votes
2 answers
Sphinx: Show all results order by previous searches
I use SphinxQL for searching and filtering in product database and I store last x search phrases of each user. I wonder if is it possible to show all products (all rows) to every user but with relevance on previous search.
Let's say one user sought…
hovado
- 4,474
- 1
- 24
- 30
0
votes
0 answers
Sphinx - How to add a real-time index on-the-fly?
We're currently running Sphinx with Real-Time Index on a production server. Our multi-tenant architecture means we maintain an individual index for each tenant (we separate our tenants into individual databases, and opted to maintain this isolation…
user984976
- 1,314
- 1
- 12
- 21
0
votes
1 answer
How to search and join multi indexes with SphinxQL?
I have 2 indexes, indexA and indexB. There 2 indexes have different columns.
Example:
Index A:
+---+-----+
|id |text |
+---+-----+
|1 |john |
|2 |tom |
|3 |sam |
+---+-----+
Index B:
+---+---------+-----+
|id |parentid |num …
King Max
- 45
- 2
- 6
0
votes
1 answer
Sphinxql with PDO php
I am integrating Sphinxsearch into my site, and rewriting my old code to use Sphinx.
The problem i got is with special characters inside MATCH in SphinxQL.
Example : want to search for H&M
With plain mysql i get thousand of records, so im quite sure…
Doktor83
- 27
- 1
- 7
0
votes
1 answer
SphinxQL - Perfect Search Mode for 1 to 4 words
I'm working on a project with Sphinx Search Engine using SphinxQL. My problem is the following:
This is my sphinxql query:
"SELECT *, country FROM all_gebrauchte_products WHERE MATCH('@searchtext (".$searchQuery.")') AND country='".$where."' ORDER…
Ingmar Erdös
- 517
- 8
- 18
0
votes
1 answer
SphinxQL - how to filter behind match
I'm working on a project where I use Sphinx searchengine. But - as I realized - the Sphinx documentation is big but hard to understand.
So I was not able to find any information on how to use the WHERE clause to filter behind a MATCH-statement. What…
Ingmar Erdös
- 517
- 8
- 18