I have to get today’s data in MySQL query.
x
SELECT
SUM(score) AS tscore,
(SELECT
players.id_company
FROM
players
WHERE
id = 377) AS id_company,
(SELECT
SUM(players_score.score),
DATE_FORMAT(players_score.reg_dt, '%Y-%m-%d')
FROM
players_score
WHERE
id_player = 377
AND DATE(reg_dt) = CURDATE())
FROM
players_score
WHERE
id_player = 377
In this query, it shows the error message that we can select one column which is understandable as I have used (col1, col2(for date)) as col. but I need a solution to get this done. thanks
Advertisement
Answer
If you need today’s data only, You should use the condition at the last only –
SELECT
SUM(score) AS tscore,
(SELECT
players.id_company
FROM
players
WHERE
id = PS.id_player) AS id_company, -- I have changed the 377 to players_score to make the query more dynamic.
SUM(players_score.score),
DATE_FORMAT(players_score.reg_dt, '%Y-%m-%d')
FROM
players_score PS
WHERE
id_player = 377
AND DATE(reg_dt) = CURDATE()