Sphinx and related tables


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
7 views
MySQL.
There are 2 signs: the company (company) and address (adress).
Are connected by relation one to many. — ie one company can have multiple addresses.

Each location has coordinates: x, y (stored as float).

Want to find companies, addresses, which are in a certain rectangular area (that is, it is necessary that x and y were within the specified range).

Also required certain restrictions on the company (took them down), so is used to index the plate with the companies, not addresses.

That's exactly what will not work:
— sql_attr_multi will not help — it can only work with the types uint, timestamp
— sql_joined_field only works with text.

It remains only to cut off x,y 3-4 characters and translate them to integer, and then use sql_attr_multi but really don't want to do.

However, is there any alternative way? Sphinx is familiar with 1 day only, so all of its features don't know.
by | 7 views

1 Answer

0 like 0 dislike
filterRange?
by

Related questions

0 like 0 dislike
3 answers
asked Apr 11, 2019 by kovalenko_jul_s
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
asked Mar 21, 2019 by ha2bj
0 like 0 dislike
3 answers
asked Mar 25, 2019 by ruskar
110,608 questions
257,186 answers
0 comments
27,850 users