<div>
select * from tablname<br />
where Name like 'A%'<br />
<br />
will return all names start with 1
</div>


select * from tablname
where Name like 'A%'

will return all names start with 1

<div>
<div class="content wysiwyg-content">
I'm building a directory. I wish the items to be searchable by the first character. How can i return all items in which the field &quot;Name&quot; letter starts with the letter &quot;A&quot;
</div>
</div>


I'm building a directory. I wish the items to be searchable by the first character. How can i return all items in which the field "Name" letter starts with the letter "A"

how to create an a-z in sql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.