Questions tagged [sql-match-all]
51 questions
0
votes
4 answers
Querying based on a set of Named Attributes/Values
I am working with a set of what is essentially Attribute/Value pairs (there's actually quite a bit more to this, but I'm simplifying for the sake of this question). Effectively you can think of the tables as such:
Entities…
Mark Roddy
- 27,122
- 19
- 67
- 71
0
votes
1 answer
How to do nested boolean filters for finding exact matcing values on same field in elasticsearch?
My Index mapping is shown below:
curl -X PUT localhost:9200/testing/listings/_mapping -d '{
"listings" : {
"properties" : {
"address" : {
"properties": {
"location": { "type" : "string",
"index" :…
Murali Selvaraj
- 55
- 11
0
votes
3 answers
mysql cross join not in?
Using a query like below you can fetch rows in which the color of the id is blue, purple, green, white, and black.
SELECT t1.id, col
FROM extra as e INNER JOIN your_table as t1 USING ( id )
CROSS JOIN your_table as t2 USING ( id )
CROSS JOIN…
Roger
- 593
- 3
- 9
- 16
0
votes
3 answers
Query different IDs with different values?
I'm trying to write a query for a golf database. It needs to return players who have statisticID = 1 with a p2sStatistic > 65 and who also have statisticID = 3 with p2sStatistic > 295.
One statisticID is driving distance, the other accuracy, etc.…
GaryRoyce
- 11
- 3
0
votes
3 answers
SQL Get All Results That Relate To All Keys
I've got a table that relates words to each other.
table_word_relationships
+-------------+-------------+
| WORD_A | WORD_B |
+-------------+-------------+
| cat | dog |
+-------------+-------------+
| cat | …
Howard Zoopaloopa
- 3,798
- 14
- 48
- 87
-1
votes
2 answers
Need help building MySQL SELECT query
So I have a table with columns:
deck_id, card_name, quantity, board(irrelevent for this question)
Each row has a deck id which is what I need, a card name, and amount of aforementioned cards.
It would look something like this:
101,…
user594044
- 255
- 2
- 4
- 13