pgrevents Posted June 12, 2009 Share Posted June 12, 2009 How would I go about getting a mysql Select query to search by letter for example I am searching the a field called titled and lets say I only want to search by their first letter lets say i have two titles; Alpha Bravo I only want to see the Bravo so the SELECT would be defined by B how would I go about this. thanks Paul Quote Link to comment https://forums.phpfreaks.com/topic/161915-solved-sort-by-letter/ Share on other sites More sharing options...
trq Posted June 12, 2009 Share Posted June 12, 2009 SELECT title FROM tbl WHERE title LIKE 'B%'; Quote Link to comment https://forums.phpfreaks.com/topic/161915-solved-sort-by-letter/#findComment-854296 Share on other sites More sharing options...
pgrevents Posted June 12, 2009 Author Share Posted June 12, 2009 thanks : ) Quote Link to comment https://forums.phpfreaks.com/topic/161915-solved-sort-by-letter/#findComment-854299 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.