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? Quote 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]" Quote 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 ' Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.