phpretard Posted March 17, 2008 Share Posted March 17, 2008 I would like to show all content that begins with the letter W. $result = mysql_query("SELECT --a row-- FROM --a table-- --but only the information that starts with W--"); any thoughts? Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/ Share on other sites More sharing options...
crashmaster Posted March 17, 2008 Share Posted March 17, 2008 WHERE {row} LIKE 'w%' Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/#findComment-494353 Share on other sites More sharing options...
trq Posted March 17, 2008 Share Posted March 17, 2008 SELECT fld FROM tbl WHERE fld LIKE 'w%'; Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/#findComment-494354 Share on other sites More sharing options...
phpretard Posted March 17, 2008 Author Share Posted March 17, 2008 What does the % do? Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/#findComment-494355 Share on other sites More sharing options...
phpretard Posted March 17, 2008 Author Share Posted March 17, 2008 Thank you for the quick response!!! Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/#findComment-494363 Share on other sites More sharing options...
revraz Posted March 17, 2008 Share Posted March 17, 2008 Wildcard What does the % do? Link to comment https://forums.phpfreaks.com/topic/96605-alphabet-order/#findComment-494378 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.