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 

[koniol2]

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

cos takiego wymyslilem ale nie działa