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. Link to comment https://forums.phpfreaks.com/topic/60932-solved-display-a-db/ 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 Link to comment https://forums.phpfreaks.com/topic/60932-solved-display-a-db/#findComment-303193 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. Link to comment https://forums.phpfreaks.com/topic/60932-solved-display-a-db/#findComment-303194 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.