hmm.. field 1rst letter

[jamesp0tter]

4 example, i have table:

id | field1
--------------
1 | abc
2 | bcd
3 | aaa
4 | cde
5 | afg

what's the query to get the field1's that start with an 'a' ? tkx

 

[swampBoogie]

select * from aTable where field1 like 'a%'

 

[jamesp0tter]

tkx