papaface Posted September 19, 2007 Share Posted September 19, 2007 Hello, How can I find any record where the first character is a number? I have this 'WHERE alias RLIKE "[0-9]" But that finds any records with numbers in them, when I just want it to be the first letter. regards Quote Link to comment Share on other sites More sharing options...
effigy Posted September 20, 2007 Share Posted September 20, 2007 ^[0-9] Quote Link to comment 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.