So I have a system that allows a user to submit a game review. This works great and all, but I want to make it so a page will list all my table entrees (reviews) that start with a certain letter. For example a page that was mean’t to list all reviews starting with the letter A, what would be the correct way of doing this? I know I want to do “WHERE” or “ORDER BY” but I don’t know how to the exact syntax for calling just the reviews with the first letter of the review.
I know one method would be to make a new value called “Section” and have the sections be A-Z allowing the user to pick the section, but I would prefer not to do this.
Any help would be appreciated!
