SELECT * FROM (	SELECT 
						CASE dayofweek(NOW()) 
						WHEN 1 THEN "Dimanche"
						WHEN 2 THEN "Lundi"
						WHEN 3 THEN "Mardi" 
						WHEN 4 THEN "Mercredi" 
						WHEN 5 THEN "Jeudi" 
						WHEN 6 THEN "Vendredi" 
						WHEN 7 THEN "Samedi"  
						ELSE "plus" END
					AS today,
						CASE dayofweek(DATE_ADD(NOW(), INTERVAL 1 DAY)) 
						WHEN 1 THEN "Dimanche"
						WHEN 2 THEN "Lundi"
						WHEN 3 THEN "Mardi" 
						WHEN 4 THEN "Mercredi" 
						WHEN 5 THEN "Jeudi" 
						WHEN 6 THEN "Vendredi" 
						WHEN 7 THEN "Samedi"  
						ELSE "plus" END
					AS tomorrow
					FROM (
						'2007-05-01' AS date_from
					)
					as init1
				) 
as init2;