MySQL query with multiple AND and OR conditions in WHERE for text values
I'm trying to build a query for a large number of rows with text.
The conditions are:
The column text MUST contain either the terms 'A' OR 'B'.
It also must contain either the terms 'C', 'D', ... OR 'Z'
So some valid results should be
'A C'
'A B D'
'B D Z'
In other words, the results must contain anything from A to B AND anything from C to Z
SELECT *
FROM documents
WHERE text ...
Thanks.
mysql
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
add a comment |
I'm trying to build a query for a large number of rows with text.
The conditions are:
The column text MUST contain either the terms 'A' OR 'B'.
It also must contain either the terms 'C', 'D', ... OR 'Z'
So some valid results should be
'A C'
'A B D'
'B D Z'
In other words, the results must contain anything from A to B AND anything from C to Z
SELECT *
FROM documents
WHERE text ...
Thanks.
mysql
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
1
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07
add a comment |
I'm trying to build a query for a large number of rows with text.
The conditions are:
The column text MUST contain either the terms 'A' OR 'B'.
It also must contain either the terms 'C', 'D', ... OR 'Z'
So some valid results should be
'A C'
'A B D'
'B D Z'
In other words, the results must contain anything from A to B AND anything from C to Z
SELECT *
FROM documents
WHERE text ...
Thanks.
mysql
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
I'm trying to build a query for a large number of rows with text.
The conditions are:
The column text MUST contain either the terms 'A' OR 'B'.
It also must contain either the terms 'C', 'D', ... OR 'Z'
So some valid results should be
'A C'
'A B D'
'B D Z'
In other words, the results must contain anything from A to B AND anything from C to Z
SELECT *
FROM documents
WHERE text ...
Thanks.
mysql
mysql
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
asked Nov 23 '18 at 18:03
NicolasVegaNicolasVega
223
223
1
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07
add a comment |
1
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07
1
1
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07
add a comment |
1 Answer
1
active
oldest
votes
You can use REGEXP for the character range match:
SELECT *
FROM documents
WHERE text REGEXP '[AB]' AND text REGEXP '[C-Z]'
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53451216%2fmysql-query-with-multiple-and-and-or-conditions-in-where-for-text-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use REGEXP for the character range match:
SELECT *
FROM documents
WHERE text REGEXP '[AB]' AND text REGEXP '[C-Z]'
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
add a comment |
You can use REGEXP for the character range match:
SELECT *
FROM documents
WHERE text REGEXP '[AB]' AND text REGEXP '[C-Z]'
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
add a comment |
You can use REGEXP for the character range match:
SELECT *
FROM documents
WHERE text REGEXP '[AB]' AND text REGEXP '[C-Z]'
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
You can use REGEXP for the character range match:
SELECT *
FROM documents
WHERE text REGEXP '[AB]' AND text REGEXP '[C-Z]'
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
answered Nov 23 '18 at 18:14
Salman ASalman A
180k66339431
180k66339431
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
add a comment |
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
1
1
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
Might want to include word-boundary markers going by OP's examples
– Vasan
Nov 23 '18 at 18:19
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53451216%2fmysql-query-with-multiple-and-and-or-conditions-in-where-for-text-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
See: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Strawberry
Nov 23 '18 at 18:07