papaface Posted September 19, 2007 Share Posted September 19, 2007 Hi, Regulars have probably seen this answered hundreds of times but how do you get records with the first letter beginning with 'a' for example? I have this: $letter = $_GET['l']; // = a $query = mysql_query('SELECT alias FROM badmembers WHERE alias RLIKE "^'.$letter.'$"'); But it doesnt seem to work.... Link to comment https://forums.phpfreaks.com/topic/69847-solved-get-any-record-where-the-first-letter-is-x/ Share on other sites More sharing options...
papaface Posted September 19, 2007 Author Share Posted September 19, 2007 whoops it does work. Thanks anyway lol Link to comment https://forums.phpfreaks.com/topic/69847-solved-get-any-record-where-the-first-letter-is-x/#findComment-350865 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.