In the example I had to find movie titles between the range A to J which was successful using the below statement.
SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';
I tried modifying the above statement to look for genre between A to J using the below statement but showed no query result
SELECT * FROM movies WHERE genre BETWEEN 'A' and 'C';
Could anyone point out what is the problem ,both name and genre use text syntax.
Thanks in advance