Stack Overflow
Stack Overflow

Questions tagged [sphinxql]

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

120 questions
0
votes
1 answer

Differentiate MySQL and Sphinx searchd

I'm running Sphinx searchd server on ports 9312 and 9306 (mysql41) and I connect to the server with the following code to use SphinxQL: $mysqli = new mysqli($hostname, $username, $password, $database, "9306"); When I send a SQL statement, it gives…
Mark Renton
  • 101
  • 2
  • 7
0
votes
1 answer

Creating Real-Time Indexes in Sphinx

I'm stuck at creating a real-time index with sphinx search engine. I'm following the documentation but I get weird results: mysql> attach index profile to rtindex rt_profile; ERROR 1064 (42000): sphinxql: syntax error, unexpected PROFILE, expecting…
user628896
  • 225
  • 2
  • 9
0
votes
1 answer

SphinxQL infix search

I am trying to use Sphinx RT index for my website. Everything works except infix searching. index rt { type = rt path = /var/lib/sphinxsearch/data/rt.sph rt_field = name rt_field = address rt_field = keyword rt_attr_uint = type …
Harikrishnan Viswanathan
  • 123
  • 3
0
votes
0 answers

GEO2D function without index on Sphinx Search

I would like to use the GEO2D function in Sphinx (SphinxQL) but I would like to use it without searching an index. I have the polygon and the latitude and longitude already and just want to calculate if the point is inside the polygon. So this is…
Nin
  • 2,960
  • 21
  • 30
0
votes
2 answers

SphinxQl add comments - How to write in log files

I have fetching records from SphinxQl . Here i have to be find out howmany sphinxQL querys coming to server. As the same i have to be know any options is there to add comments in sphinxQl query. Please help me to findout the solutions.
karthik
  • 36
  • 10
0
votes
1 answer

sphinxQL fetching random?

In SphinxQL, how do I get random records from index? SELECT fname FROM indexname WHERE Age>=21 and Age<=47 random 0,4 \G; Getting following error: sphinxql: syntax error, unexpected CONST_INT, expecting BETWEEN (or 8 other tokens) near '0,4 Any…
karthik
  • 36
  • 10
0
votes
1 answer

field-end modifier is not working in SphinxQL

When I filtering exact word by column filed-end modifier is not working. here is the example: SELECT * FROM indexTable WHERE MATCH('@column1 ^abc$'); this returns me: (not only exact "abc") abc abc a abc d is there any solution in config or…
user1587263
  • 23
  • 6
0
votes
1 answer

SphinxQL - How to match words within a single string

I have the following and several other strings indexed. All words are glued together. Stringisaflexiblepieceofropeortwinewhichisusedtotie,bind,orhangotherobjects. Which is a sentence from wikipedia. String is a flexible piece of rope or twine…
Aley
  • 8,540
  • 7
  • 43
  • 56
0
votes
1 answer

SphinxQL - How to order by date without a search query

I have the following sphinx query SELECT * FROM cars WHERE MATCH('car'); This is working perfectly fine when I need to search for 'car'. Lets say you have a search field where someone enters 'car', but what if one enters an empty string ''? In this…
Aley
  • 8,540
  • 7
  • 43
  • 56
0
votes
2 answers

Using multiple indexes in SphinxQl and searching across fields from multiple indexes

So guys I have multiple indexes in Sphinx eg 3 Indexes index1 Fields: field1_1,field1_2,field1_3 index2 Fields: field2_1,field2_2,field2_3 index3 Fields: field3_1,field3_2,field3_3 I want to search across these three indexes and my search string…
Rajul
  • 5,906
  • 2
  • 22
  • 26
0
votes
1 answer

SphinxQL - what means comma in MATCH query

my question is: what is the mining of the following matching parts of query (SphinxQL): 1. MATCH('php, programmer') 2. MATCH('php,programmer') 3. MATCH('php programmer') And what is the difference in meaning of this query when using PHP…
Gabriel Filipiak
  • 966
  • 12
  • 24
0
votes
1 answer

Status field couldnt fetch

Using SphinxQl, I could not fetch status fields from particular index. If I try to fetch the status fields, I will get following errors. Please any one help to solve that issue? Example: Select Status from tablename; I got following error: syntax…
karthik
  • 36
  • 10
-1
votes
1 answer

How do I find mispelled words with sphinx?

Let's say I have the word "catheter". A user tries to search on my web app for that word but spells it "cathiter" or "cattiter" instead. How can I use SphinxQL to match the word from my SQL database based on the incorrectly spelled word? What would…
Hayden
  • 779
  • 10
  • 18
-1
votes
1 answer

sphinx filter by relation column

i have 2 tables: apartment building each apartment have building_id apartment has "floor" column, where is stored apartment floor. each building has "totalFloors" column, where is stored total floors(for example, current apartment is 3 of 9 floor) i…
ideea
  • 353
  • 1
  • 3
  • 10
-3
votes
1 answer

sphinxql: syntax error, unexpected NULL, expecting CONST_INT (or 5 other tokens) near 'NULL,1448734444)'

The error is this: sphinxql: syntax error, unexpected NULL, expecting CONST_INT (or 5 other tokens) near 'NULL,1448734444)' How delete this index id = 1448734444, thank you I don't know how to use sphinx,and where is sphinx's database
lpc
  • 1
1 2 3 4 5 6 7
8