a SQL dialect that enables Sphinx search functionality in a standard SQL syntax.
Questions tagged [sphinxql]
120 questions
0
votes
1 answer
Sphinx / SphinxQL - Setting weights on select
I'm using Sphinx, and I'm trying to execute the next query in mysql:
SELECT *
FROM `index_efemerides`, `index_programas`, `index_guias_para_el_aula`, `index_producciones_interactivas`
WHERE MATCH('(@(titulo,descripcion,etiquetas) nuevo)')
OPTION…
Gabriel Moreira
- 29
- 10
0
votes
1 answer
Set match mode on SphinxQl in sphinxsearch
I use SphinxQl, I got query like this
SELECT `id`, WEIGHT() as relevance FROM `rt_table` WHERE MATCH('dubai')
I want to set match mode extended to make search by * (wildcard) like
SELECT `id`, WEIGHT() as relevance FROM `rt_table` WHERE…
Aramayis Mkrtchyan
- 339
- 3
- 12
0
votes
1 answer
Sphinx Search - Compare two lists of data
Lists (both lists fields is equal) example:
name(rt_field): Aaaaaa
attr1(rt_attr_uint): 3
attr2(rt_attr_uint): 0
attr3(rt_attr_multi): (a,b,c,d...)
My goal is to find equal data in both lists.
The way i do it now - I get one list from MySQL db and…
o139
- 854
- 2
- 8
- 20
0
votes
1 answer
SphinxQL Vendor Order Random
I just installed on my server SphinxQL Vendor (I'm new to this) and I have a problem - I can't find a way to make the script work via random select.
This is my code:
require "./classes/vendor/autoload.php";
use Foolz\SphinxQL\SphinxQL;
use…
Matei Zoc
- 3,739
- 3
- 16
- 18
0
votes
1 answer
Sphinx search in codeigniter
I have installed sphinx on my server, indexed it and running query successfully. I am using sphinxrt code from https://github.com/andrew-s/codeigniter-sphinxrt to search but, it always give me the search for exact phrase.
I am not able to search as…
HKumar
- 1,535
- 3
- 13
- 28
0
votes
1 answer
How to update Sphinx Realtime Index with field = old_value + new_value?
I am trying to update the Sphinx Search Realtime Index , using values from my Mysql Table.,
I want to add the new value in the old value of the RT index's record like this ,
i want to achieve this
UPDATE RT_index SET col1 = old_val + new_val WHERE…
user1642018
0
votes
2 answers
Sphinx - How to escape user input for SphinxQL?
I have website where users can search posts by entering keywords,
I am using Sphinx search for full text search, everyhting is working as expected.
But when i enter/input some special charaters in search query the search dosnt complete and throws…
user1642018
0
votes
1 answer
Sphinx RT Index - Is there any way to set max_matches in Index definition
I am using SphinxQL for querying RT Index and it contains multi million records. My problem is when i tried to query second page of result set
$searches = $prepStatement->query("select * from searchAnalytics limit…
Vimson
- 89
- 2
- 10
0
votes
1 answer
How to connect to SphinQL Query Builder?
I'm using Ubuntu 12.04 + PHP + Nginx + MySQL 5.6
My project path is /usr/share/nginx/www/project1
I've installed Sphinx successfully and able to connect thorough API. But I like to use SphinxQL Query Builder.
I am not familiar with composer and php…
Tuhin
- 91
- 1
- 2
- 8
0
votes
0 answers
Installing SphinxQL in Php
I followed all the steps in this guide, and have successfully installed Sphinx on my Ubuntu 14.04 server. However, I am not able to use SphinxQL (by Foolz) in my php pages. This is the code I am using :
Sainath Krishnan
- 2,089
- 7
- 28
- 43
0
votes
1 answer
Sphinx infix match by one character
My index configuration:
index my_index
{
# ...
type = rt
phrase_boundary = ., ?, U+2026
charset_table = 0..9, english, russian, _
dict = keywords
min_word_len = 1
min_infix_len = 1
preopen = 1
rt_field =…
Nikita
- 21
- 1
- 5
0
votes
1 answer
How to return rows that do not match a value in a column?
The Sphinx documentation has a simple example on using SphinxQL:
SELECT * FROM test WHERE MATCH('@title hello @body world')
Let's say I add a varchar column to the table called ids which contains integer values separated by something such as a…
Nate
- 26,164
- 34
- 130
- 214
0
votes
1 answer
SphinxQL doesn't work with prepared statements?
I found several threads on the Sphinx forum discussing this issue:
http://sphinxsearch.com/forum/view.html?id=5974
My function for creating a DB connection:
function createSphinxPdo()
{
try {
$options = [
…
Nate
- 26,164
- 34
- 130
- 214
0
votes
1 answer
Sphinx PHP API EscapeString() function doesn't work for SphinxQL?
I found the following function in the Sphinx PHP API code:
function sphinxapi_EscapeString($string)
{
$from = ['\\', '(', ')', '|', '-', '!', '@', '~', '"', '&', '/', '^', '$', '=', '<'];
$to = ['\\\\', '\(', '\)', '\|', '\-', '\!', '\@',…
Nate
- 26,164
- 34
- 130
- 214
0
votes
1 answer
SphinxQL error really basic
Here's my query:
SELECT `person_id` FROM `123numbers` WHERE MATCH('john smith')
Here's the error I get:
[1064] sphinxql: syntax error, unexpected $undefined, expecting IDENT near '`123numbers` WHERE MATCH('john smith')' [ SELECT `person_id` FROM…
wanted
- 358
- 3
- 12