Jester Posted February 6, 2003 Share Posted February 6, 2003 Merry Meet! Now I have a big problem with php + mysql the main source of the problem is query so I posted this up here; My problem: Now I am coding a site for recepies and I want my users to be able to list the recepies according to their first letter (ex all the recepies starting with a) Now I tired really hard to the Left function but I just haven\'t been able to make sql to return the result of a query like this: we have a column say name I wnt eury to match up the first letter of every entry in name with the one given by the user... Spent almost 3 hours playing with the \"LEFT()\" thingie but it doesn\'t work theway it should =) Kind Regards The Jester Quote Link to comment https://forums.phpfreaks.com/topic/128-listing-query-results/ Share on other sites More sharing options...
effigy Posted February 7, 2003 Share Posted February 7, 2003 select * from recipes where name like \'a%\' just code it to make the letter part dynamic... Quote Link to comment https://forums.phpfreaks.com/topic/128-listing-query-results/#findComment-385 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.