mysql - mysqli- php Select rows with >3 consecutive same valued fields -

i'm trying select book_no of rows 3 or more consecutive dues far have not been able it.

this table:  | book_no | name | mobile | date1 | date2 | date3 | date4 | date5 | |---------|------|--------|-------|-------|-------|-------|-------| |    1    | cell |        | paid  | due   | due   |       |       | |    2    | cell |        | paid  | paid  | paid  |       |       |  |    3    | cell |        | due   | due   | due   | due   |       | |    4    | cell |        | paid  | paid  | paid  |       |       |  |    5    | cell |        | due   | due   | due   |       |       | 

so query should return rows book_no's 3,5

please help

just go through each possibility or 'due' being in 3 columns, not shortest query works, example

select book_no books (date1 = 'due' , date2 = 'due' , date3 = 'due') or (date2 = 'due' , date3 = 'due' , date4 = 'due') or (date3 = 'due' , date4 = 'due' , date5 = 'due') or (date1 = 'due' , date3 = 'due' , date4 = 'due') or (date1 = 'due' , date4 = 'due' , date5 = 'due') or (date2 = 'due' , date4 = 'due' , date5 = 'due') or (date1 = 'due' , date2 = 'due' , date4 = 'due') or (date1 = 'due' , date2 = 'due' , date5 = 'due') or (date2 = 'due' , date3 = 'due' , date5 = 'due') or (date1 = 'due' , date3 = 'due' , date5 = 'due');