<div>
select * from mytable where title like 'a%'<br />
select * from mytable where title like 'j%'<br />
select * from mytable where title like '0%'
</div>


select * from mytable where title like 'a%'
select * from mytable where title like 'j%'
select * from mytable where title like '0%'

<div>
SELECT * FROM Table WHERE SUBSTRING(title,1,1)='a'
</div>


SELECT * FROM Table WHERE SUBSTRING(title,1,1)='a'

<div>
This was the most important to me:<br />
select * from mytable where title &gt;= '0' and title &lt;='9'<br />
<br />
thanks!<br />

</div>


This was the most important to me:
select * from mytable where title >= '0' and title <='9'

thanks!


<div>
<div class="content wysiwyg-content">
Hello,<br />
i have a field called &quot;title&quot; in my table, can you tell me the sql statement to select the row if the first alphabet of the title is &quot;a&quot;?<br />
<br />
for example here are 3 rows:<br />
jack is a good boy<br />
jill is sillu<br />
abby is naughty<br />
kevin is lazy<br />
<br />
If i do a search on &quot;j&quot; then both jack and jill should come back as results...<br />
and lastly, how to do this if the first character is a number from 0-9?<br />
<br />
Thanks!
</div>
</div>


Hello,
i have a field called "title" in my table, can you tell me the sql statement to select the row if the first alphabet of the title is "a"?

for example here are 3 rows:
jack is a good boy
jill is sillu
abby is naughty
kevin is lazy

If i do a search on "j" then both jack and jill should come back as results...
and lastly, how to do this if the first character is a number from 0-9?

Thanks!

select first alphabet from title

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.