Stack Overflow
Stack Overflow

Questions tagged [sphinxql]

a SQL dialect that enables Sphinx search functionality in a standard SQL syntax.

120 questions
0
votes
0 answers

Query Builder for SphinxQL - access and compare columns against each other from the Match method

Am trying to search my sphinx index instance but can't seem to get it working with my current logic. Basically, am using Query Builder for SphinxQL instead of the offical API but works pretty well until I tried comparing columns against each without…
Dennisrec
  • 333
  • 2
  • 22
0
votes
1 answer

Order manticore/sphinx results by full text field alphabetically

I have a manticore index with the following configuration: index book_archive { type = rt path = /book_archive rt_field = title rt_field = author charset_table = non_cjk, cjk stored_fields = title, author } I am trying to do…
tmello01
  • 109
  • 1
  • 3
  • 11
0
votes
3 answers

How to Add OR Condition in Laravel Sphinx query?

I am using the fobia/laravel-sphinx package and want to add a condition like city != 0 or state != 0 but the or condition is not working and gives tjis error: "Syntax error or access violation: 1064 sphinxql: syntax error, unexpected OR, expecting…
Sejal Gauswami
  • 3
  • 2
0
votes
1 answer

Does Sphinx index capital letters as the beginning of a word? If so what setting can over-ride this?

I just discovered an issue when searching for iOS as IOS and it wasn't found. So I tested on other words e.g Market. It is found by Market and MARKET and even MARKEt. Where it breaks is if I make any other letter caps, i..e Camel Case: mArket,…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Are there more robust SphinxQL Diagnostics other than Show Meta?

I have a pretty complex sphinx index. Recently I was getting results on an important word in most of my searches and was getting false positives (meaning text records without the word at all). In order to see what was going on I did show meta to see…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Geodist with where or match

I need combine this 2 query in one, and sort by Id, select GEODIST(40, 50, latitude,longitude, {in=degrees, out=meters}) AS distance, id FROM offersRT WHERE distance<=1000 LIMIT 0,30; and select 0 as distance, id FROM offersRT WHERE…
Black Jack
  • 11
  • 5
0
votes
1 answer

Manticore - FACET by JSON, using the key of the JSON array

I have an index of data in Manticore that includes a JSON field (called readings that is structured like this: { "temperature": 12.3, "light": 45.5, "battery": 3422, .... } I'm wanting to facet the results such that I can display…
fistameeny
  • 1,048
  • 2
  • 14
  • 27
0
votes
1 answer

Output of Show Meta in SphinxQL

I am trying to check if my config has issues or I am not understanding Show Meta correctly; If I make a regex in the config: regexp_filter=NY=>New York then if I do a SphinxQL search on 'NY' Search Index where MATCH('NY') and then Show Meta it…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Sphinx - How to get an Exact Match, i.e. same as mysql WHERE column = "value"

I've got a real time index containing information on people (a definition is included below). The problem is that I'm trying to run an exact match on a phone number and email address and no matter what I try, I'm getting matches even if the database…
Steve Childs
  • 1,832
  • 2
  • 20
  • 26
0
votes
1 answer

Sphinx, snippets and partial word matches

We're using sphinx and snippets to do a basic site search. SELECT id FROM search WHERE MATCH('(@keywords corona)') And we're getting matches on "coronavirus" and "coronary" like we would expect. But when we later use CALL SNIPPETS( 'Wuhan…
Andy Preston
  • 779
  • 4
  • 9
  • 23
0
votes
1 answer

Manticore - sphinxQL GROUP BY duplicated grouped id

When I using GROUP BY syntax in Manticore, there are results with duplicated grouped id. We've just migrated from sphinx 2.X to the latest Manticore, and in Sphinx there wasn't this promlem with the same query. This is the sphinxQL query: SELECT…
Lay András
  • 795
  • 2
  • 9
  • 14
0
votes
1 answer

Give weights to matching fields

Have a problem with Sphinxql. I try to match several fields and give each a weight. select id ,item ,param1 ,param2 ,module_id ,param2_id ,date_change ,custom_rank ,weight() as rank …
Sizuji
  • 868
  • 2
  • 9
  • 26
0
votes
1 answer

How to use SNIPPET function in SphinxQL?

I have an index: -------------------------------------------------- | id | name | folder | tag1 | tag2 | topic | -------------------------------------------------- | 1 | file 1 | AAA | [1,2] | [3,4] | 1 …
slavkovl
  • 21
  • 6
0
votes
1 answer

How to filter JSON in SphinxQL?

I have a JSON field with a simple numeric array [46,70,34] How can I filter query selecting only those rows where present let's say '70' in a JSON field? Something similar to JSON_CONTAINS in MySQL. I have already tried SELECT id, name, IN(tags,…
slavkovl
  • 21
  • 6
0
votes
1 answer

How do ordering by rank and fields relate to each other in Sphinx search?

Suppose I have a query like this: SELECT FROM example ORDER BY somefield ASC OPTION ranker=bm25 This seems contradictory. How is it going to sort? By somefield only? Or by BM25 rank only? Or both? If both then which is the most…
Gherman
  • 6,768
  • 10
  • 48
  • 75
1 2
3
4 5 6 7 8