Select count if column name contain and value equal to something MYSQL
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
-5
Here is my table call TrainingPresence
+-------+-----------+-----------+-----------+
| Name | FootNov12 | HandNov15 | FootNov22 |
+-------+-----------+-----------+-----------+
| Clem | x | Abs | Abs |
+-------+-----------+-----------+-----------+
| Kevin | x | x | x |
+-------+-----------+-----------+-----------+
I want to select the name and the number of time when player came to the Foot training.
FootNov12 = Football Novembrre 12th
FootNov22 = Football November 22th
HandNov15 = Handball November 15th
The select query should give me :
Name | Count
Clem | 1
Kevin| 2
But I don't know how to do it
Thanks for your help.
mysql select count multiple-columns
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
|
show 1 more comment
-5
Here is my table call TrainingPresence
+-------+-----------+-----------+-----------+
| Name | FootNov12 | HandNov15 | FootNov22 |
+-------+-----------+-----------+-----------+
| Clem | x | Abs | Abs |
+-------+-----------+-----------+-----------+
| Kevin | x | x | x |
+-------+-----------+-----------+-----------+
I want to select the name and the number of time when player came to the Foot training.
FootNov12 = Football Novembrre 12th
FootNov22 = Football November 22th
HandNov15 = Handball November 15th
The select query should give me :
Name | Count
Clem | 1
Kevin| 2
But I don't know how to do it
Thanks for your help.
mysql select count multiple-columns
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
2
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
2
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34
|
show 1 more comment
-5
-5
-5
0
Here is my table call TrainingPresence
+-------+-----------+-----------+-----------+
| Name | FootNov12 | HandNov15 | FootNov22 |
+-------+-----------+-----------+-----------+
| Clem | x | Abs | Abs |
+-------+-----------+-----------+-----------+
| Kevin | x | x | x |
+-------+-----------+-----------+-----------+
I want to select the name and the number of time when player came to the Foot training.
FootNov12 = Football Novembrre 12th
FootNov22 = Football November 22th
HandNov15 = Handball November 15th
The select query should give me :
Name | Count
Clem | 1
Kevin| 2
But I don't know how to do it
Thanks for your help.
mysql select count multiple-columns
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
Here is my table call TrainingPresence
+-------+-----------+-----------+-----------+
| Name | FootNov12 | HandNov15 | FootNov22 |
+-------+-----------+-----------+-----------+
| Clem | x | Abs | Abs |
+-------+-----------+-----------+-----------+
| Kevin | x | x | x |
+-------+-----------+-----------+-----------+
I want to select the name and the number of time when player came to the Foot training.
FootNov12 = Football Novembrre 12th
FootNov22 = Football November 22th
HandNov15 = Handball November 15th
The select query should give me :
Name | Count
Clem | 1
Kevin| 2
But I don't know how to do it
Thanks for your help.
mysql select count multiple-columns
mysql select count multiple-columns
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
edited Nov 26 '18 at 14:15
clement pignet
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
asked Nov 26 '18 at 13:58
clement pignetclement pignet
27
27
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
2
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
2
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34
|
show 1 more comment
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
2
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
2
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
2
2
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
2
2
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34
|
show 1 more comment
1 Answer
1
active
oldest
votes
1
A normalised Schema might look like this
users
user_id name
1 Clem
2 Kevin
training
user_id date sport
1 2018-11-15 Handball
1 2018-11-11 Football
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
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
});
}
});
draft saved
draft discarded
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%2f53482728%2fselect-count-if-column-name-contain-and-value-equal-to-something-mysql%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
1
A normalised Schema might look like this
users
user_id name
1 Clem
2 Kevin
training
user_id date sport
1 2018-11-15 Handball
1 2018-11-11 Football
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
add a comment |
1
A normalised Schema might look like this
users
user_id name
1 Clem
2 Kevin
training
user_id date sport
1 2018-11-15 Handball
1 2018-11-11 Football
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
add a comment |
1
1
1
A normalised Schema might look like this
users
user_id name
1 Clem
2 Kevin
training
user_id date sport
1 2018-11-15 Handball
1 2018-11-11 Football
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
A normalised Schema might look like this
users
user_id name
1 Clem
2 Kevin
training
user_id date sport
1 2018-11-15 Handball
1 2018-11-11 Football
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
answered Nov 26 '18 at 17:38
StrawberryStrawberry
26.8k83250
26.8k83250
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
add a comment |
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
Thank you for your answer! So I need 2 tables right?
– clement pignet
Nov 26 '18 at 19:02
1
1
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
The force is strong in this one
– Strawberry
Nov 26 '18 at 19:17
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
@clementpignet Actually you'd probably have a table of users, a schedule table, and a table of attendance. You might also have a table of sports.
– Strawberry
Nov 27 '18 at 9:43
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53482728%2fselect-count-if-column-name-contain-and-value-equal-to-something-mysql%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
Need to add more information to your questions so that others can understand your question
– lucumt
Nov 26 '18 at 14:00
2
Welcome to Stack Overflow! Please put some efforts in framing a question with relevant and minimal sample data showcasing your requirements, and corresponding expected output. Please read this link: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 26 '18 at 14:01
I edited my post to add more information, sorry about it. Is this better?.
– clement pignet
Nov 26 '18 at 14:12
You need to unpivot in a subquery before you can GROUP BY and COUNT() .. So basically this question is a duplicate here..
– Raymond Nijland
Nov 26 '18 at 14:13
2
Seriously consider revising your schema. A database table is NOT a spreadsheet!!
– Strawberry
Nov 26 '18 at 14:34