Complex Query with Sphinx

Posted by maSnun on Stack Overflow See other posts from Stack Overflow or by maSnun
Published on 2010-03-26T20:10:39Z Indexed on 2010/03/26 20:13 UTC
Read the original article Hit count: 534

Filed under:

sphinx

|

sphinx-php

|

php

|

mysql

I am using -- http://sphinxsearch.com/ . Its working fine for me except one problem. I need to exclude some entries where a specific field doesn't contain a word.

Something that would look like this in mysql:

Select * from table where yescolumn = 'query' and othercolumn not like '%keyword%'

Please help. Thanks.

© Stack Overflow or respective owner

Related posts about sphinx

Sphinx PHP search

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm doing a Sphinx search but turning up some really weird results. Any help is appreciated. So for example if I type "50", I get: 50 Cent 50 Lions 50 Foot Wave, etc. This is great, but when I search "50 Ce", I get: Ryczace Dwudziestki Spisek Bernhard Gal Cowabunga Go-Go And other crazy results… >>> More
sphinx xmlpipe2 cassandra and ruby 1.9

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I start to using cassandra and I want to index my db with sphinx. I wrote ruby script which is used as xmlpipe, and I configure sphinx to use it. source xmlsrc { type = xmlpipe2 xmlpipe_command = /usr/local/bin/ruby /home/httpd/html/app/script/sphinxpipe… >>> More
Sphinx PHP Geodist problems

as seen on Stack Overflow - Search for 'Stack Overflow'
Below is my PHP function to call nearby points using Sphinx for MySQL. There are hundreds of thousands of nearby points which to what I can tell, are being indexed by Sphinx, but simply fails silently when searching with Sphinx. Other Sphinx queries I run against other indexes work completely fine… >>> More
Problem running Thinking Sphinx with Rails 2.3.5

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I just installed Sphinx (distro: archlinux) downloading the source. Then I installed "Thinking Sphinx" plugin for Rails. I followed the official page setup and this Screencast from Ryan Bates, but when I try to index the models it gives me this error: $ rake thinking_sphinx:index (in /home/benoror/Dropbox/Proyectos/cotizahoy) Sphinx… >>> More
django error ,about django-sphinx

as seen on Stack Overflow - Search for 'Stack Overflow'
from django.db import models from djangosphinx.models import SphinxSearch class MyModel(models.Model): search = SphinxSearch() # optional: defaults to db_table # If your index name does not match MyModel._meta.db_table # Note: You can only generate automatic configurations from the ./manage… >>> More

Related posts about sphinx-php

Sphinx PHP search

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm doing a Sphinx search but turning up some really weird results. Any help is appreciated. So for example if I type "50", I get: 50 Cent 50 Lions 50 Foot Wave, etc. This is great, but when I search "50 Ce", I get: Ryczace Dwudziestki Spisek Bernhard Gal Cowabunga Go-Go And other crazy results… >>> More
Sphinx PHP Geodist problems

as seen on Stack Overflow - Search for 'Stack Overflow'
Below is my PHP function to call nearby points using Sphinx for MySQL. There are hundreds of thousands of nearby points which to what I can tell, are being indexed by Sphinx, but simply fails silently when searching with Sphinx. Other Sphinx queries I run against other indexes work completely fine… >>> More
Complex Query with Sphinx

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using -- http://sphinxsearch.com/ . Its working fine for me except one problem. I need to exclude some entries where a specific field doesn't contain a word. Something that would look like this in mysql: Select * from table where yescolumn = 'query' and othercolumn not like '%keyword%' Please… >>> More
remove all data from sphinx database

as seen on Stack Overflow - Search for 'Stack Overflow'
hi i want to know how to delete all data from sphinx table. because i would like to store new data to the table. thanks and advance. >>> More
Sphinx non-fulltext, integer only search

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello guys, I've got a few tables that literally only hold integers, no "words" and for some reason Sphinx is unable to hold this data in it's library. Just returns "0 bytes" errors for these indexes. Is it possible to do this? If so, how? Below is an example from my Sphinx.conf for one that fails… >>> More