Thank you for this and for the previous answer about create temporary table,
your RestTimes is a nice way to do it, but it multiplies the number of rows of the table. So you say it's better to have more rows than have less row, when doing simple select query? I'll do it your way then, except if somebody has a better idea ? > -----Message d'origine----- > As opposed to something like: > > RestTimes ( > id ..., > restaurantid ..., > weekday tinyint unsigned, > open ..., > close ..., > label varchar > ); --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php