How to create a query in sql where letters in the table are in the range from 'a to h' ?

Answer 1

select * from /table-name/ where /column-name/ in (a,b,c,d,e,f,g,h);

This is for selecting values in that range

I am actually not sure how to allow values only in that range......

Answer 2

I had never used BETWEEN for checking a single character field, but you might wanna give it a try;

SELECT <fields_list> FROM <table_name> WHERE <field_name> BETWEEN 'a' and 'h';

* Reference:
https://www.w3schools.com/sql/sql_between.asp

Hth, cmiiw

Answer 3

No Wa I hope you got the answer