Mixing
MySQL string REPLACE result into IN() statement
The following MySQL snipped gives me a "truncated incorrect DOUBLE value '62,72'" warning. Is something like this possible? Is there a workaround to make it work?
SELECT
c.customers_id,
GROUP_CONCAT(cgc.category_id) AS category_discount
FROM `customers` c
LEFT JOIN customers_groups_category cgc ON cgc.customers_groups_id=c.customers_groups_id AND cgc.category_id IN (REPLACE("62_72", "_", ","))
WHERE c.customers_id=1
Something about the intent of the code. It's for an ecommerce website. Products reside in categories and categories can have discounts. One table contains the entire path of category ids in a underscore separated string. I'd like to fetch all the discounts of all these category ids in one go and then return the discount of the nearest category id.
mysql
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
add a comment |
The following MySQL snipped gives me a "truncated incorrect DOUBLE value '62,72'" warning. Is something like this possible? Is there a workaround to make it work?
SELECT
c.customers_id,
GROUP_CONCAT(cgc.category_id) AS category_discount
FROM `customers` c
LEFT JOIN customers_groups_category cgc ON cgc.customers_groups_id=c.customers_groups_id AND cgc.category_id IN (REPLACE("62_72", "_", ","))
WHERE c.customers_id=1
Something about the intent of the code. It's for an ecommerce website. Products reside in categories and categories can have discounts. One table contains the entire path of category ids in a underscore separated string. I'd like to fetch all the discounts of all these category ids in one go and then return the discount of the nearest category id.
mysql
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51
add a comment |
The following MySQL snipped gives me a "truncated incorrect DOUBLE value '62,72'" warning. Is something like this possible? Is there a workaround to make it work?
SELECT
c.customers_id,
GROUP_CONCAT(cgc.category_id) AS category_discount
FROM `customers` c
LEFT JOIN customers_groups_category cgc ON cgc.customers_groups_id=c.customers_groups_id AND cgc.category_id IN (REPLACE("62_72", "_", ","))
WHERE c.customers_id=1
Something about the intent of the code. It's for an ecommerce website. Products reside in categories and categories can have discounts. One table contains the entire path of category ids in a underscore separated string. I'd like to fetch all the discounts of all these category ids in one go and then return the discount of the nearest category id.
mysql
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
The following MySQL snipped gives me a "truncated incorrect DOUBLE value '62,72'" warning. Is something like this possible? Is there a workaround to make it work?
SELECT
c.customers_id,
GROUP_CONCAT(cgc.category_id) AS category_discount
FROM `customers` c
LEFT JOIN customers_groups_category cgc ON cgc.customers_groups_id=c.customers_groups_id AND cgc.category_id IN (REPLACE("62_72", "_", ","))
WHERE c.customers_id=1
Something about the intent of the code. It's for an ecommerce website. Products reside in categories and categories can have discounts. One table contains the entire path of category ids in a underscore separated string. I'd like to fetch all the discounts of all these category ids in one go and then return the discount of the nearest category id.
mysql
mysql
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
asked Nov 22 '18 at 8:36
Floris van den BergFloris van den Berg
132
132
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51
add a comment |
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51
add a comment |
0
active
oldest
votes
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%2f53426806%2fmysql-string-replace-result-into-in-statement%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53426806%2fmysql-string-replace-result-into-in-statement%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
Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Please go through this link once: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 22 '18 at 8:51