Mysql sort by date?

Question

MySQL

Good afternoon, tell me how to do this kind of sorting?
We have:

$result = mysqli_query($link, "SELECT *, DATE_FORMAT(brithday, '%d.%m.%Y') as brithday 
                FROM bdtable WHERE brithday = 'year-08-day'");

those. output for a specific month, with any other values. Thank you.

Answer 1

Doka
In your case - MONTH(date)
WHERE MONTH(brithday) = 8