i want to make a select with a like where i want the start of the string to be in the range of 01..09 means : 01dfgasfasdf321 02df465as4dfwer and so on to... 09sd1231asdf how do i do that? thnaks in advance peleg
May want to just regexp that...
SELECT field FROM table WHERE field REGEXP '0[0-9]{1}+'
Something like that http://dev.mysql.com/doc/mysql/en/Regexp.html