jandrews Posted April 16, 2009 Share Posted April 16, 2009 Hi all, I need to know how to pull all fields from a database where the first letter is any number. How would i do this? Link to comment https://forums.phpfreaks.com/topic/154359-solved-please-help-with-my-query-0-9/ Share on other sites More sharing options...
Maq Posted April 16, 2009 Share Posted April 16, 2009 where the first letter is any number. A letter cannot be a number. Try: SELECT * FROM foo WHERE bar REGEXP "^[0-9]" Link to comment https://forums.phpfreaks.com/topic/154359-solved-please-help-with-my-query-0-9/#findComment-811522 Share on other sites More sharing options...
jandrews Posted April 16, 2009 Author Share Posted April 16, 2009 where the first letter is any number. A letter cannot be a number. Lol Ok character U know what I mean. Thanks tho, that works. Only thing that needed changing was " to ' Link to comment https://forums.phpfreaks.com/topic/154359-solved-please-help-with-my-query-0-9/#findComment-811540 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.