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 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... Link to comment https://forums.phpfreaks.com/topic/128-listing-query-results/#findComment-385 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.