Question on sql query?

Hi all.
Guys, this problem.
There is a table
How do I write a query so that I could calculate the column 'status', this is where open, cliked and sent.
To count only the open and cliked.
I read different manuals, but not suitable, I most likely are not looking for it.
Tried so
SELECT * FROM `statistic` WHERE `status`= 'Opened' AND `id_mes` = '253482' and SELECT * FROM `statistic` WHERE `status`= 'Cliked' AND `id_mes` = '253482'

and so
SELECT * FROM `statistic` WHERE `status`= 'Opened' AND `id_mes` = '253482' WHERE `status`= 'Cliked' AND `id_mes` = '253482'

Which consequently doesn't work.
Please give a link where to read the queries to get what I want??
August 19th 19 at 23:34
1 answer
August 19th 19 at 23:36
Yes you will arrive with a tutorial on SQL :)
SELECT * FROM `statistic` WHERE `status` in ( 'Opened','Cliked','sent') AND `id_mes` = '253482'

the same thing can be done using OR: ((status = 1) OR (status = 2) ... ) AND id = 100500
Thank you, you're a true friend))) - dorothea61 commented on August 19th 19 at 23:39

Find more questions by tags MySQLPHP PDO