# \[PHP + MYSQL\]Getting first character of a value in a table

**URL:** <https://forum.kirupa.com/t/php-mysql-getting-first-character-of-a-value-in-a-table/189077>\
**Category:** programming\
**Created:** [May 13, 2006, 7:21am UTC](https://forum.kirupa.com/t/php-mysql-getting-first-character-of-a-value-in-a-table/189077 "2006-05-13T07:21:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![evileks](https://avatars.discourse-cdn.com/v4/letter/e/cab0a1/32.png) [@evileks](https://forum.kirupa.com/u/evileks)\
**Post date:** [May 13, 2006, 7:21am UTC](https://forum.kirupa.com/t/php-mysql-getting-first-character-of-a-value-in-a-table/189077/1 "2006-05-13T07:21:17Z")

</div>

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!