Selec case Opcje

[koniol2]

date urodzenia mam 1958 jak poprawnie zrobic casa

[SQL] pobierz, plaintext 
SELECT YEAR(data_urodzenia),
    CASE 
        WHEN (YEAR(CURDATE())- YEAR(data_urodzenia)) >= '18' >='29' THEN '1'
        WHEN (YEAR(CURDATE())- YEAR(data_urodzenia)) <= '30' <='39' THEN '2'
		WHEN (YEAR(CURDATE())- YEAR(data_urodzenia)) <= '40' <='49' THEN '3'
		WHEN (YEAR(CURDATE())- YEAR(data_urodzenia)) <= '50' <='59' THEN '4'
        WHEN (YEAR(CURDATE())- YEAR(data_urodzenia)) <= '60' THEN '5'
    END AS rok
    FROM `zapisy`
    WHERE id=1
[SQL] pobierz, plaintext