ItsWesYo Posted July 20, 2007 Share Posted July 20, 2007 I already know how to display a database. But my question is how would I only display items that start with a number or certain letter? Example: Apple, Asparagus, Bat, Boy, Creek, Cool Then, I want to only display the A's only. Quote Link to comment Share on other sites More sharing options...
chigley Posted July 20, 2007 Share Posted July 20, 2007 SELECT * FROM table WHERE field LIKE 'A%' Try that query Quote Link to comment Share on other sites More sharing options...
ItsWesYo Posted July 20, 2007 Author Share Posted July 20, 2007 Thank you very much. I knew I had to use the WHERE code, but I wasn't sure how. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.