Unable to retrieve rows in sql statement

advertisements

i want to select books which have chapter 29 and books which have chapter 30 and so on. I tried the code below but it only returns books that have chapter 29 but not 30, 31, 32

SELECT distinct book FROM `bible_kjv` WHERE chapter in (29,30,31,32,33,34,35);

Please how can I rewrite code


The code seems to be fine. Could it be a problem with data types? What type is the column 'chapter' set to?