I need a mySQL request where I only find strings which contains a uppercase character before a lowercase char within a single word.
Example: fooExample
In best case only if there are at least 2 characters before the uppercase char. So it should not find: "iPhone" for example. And it must be a real char in range from a-z before A-Z.
I guess I should use the SQL function REGEXP, but I can't get it working because I'm开发者_StackOverflow社区 not very familiar with regular expression.
SELECT col
FROM tableName
WHERE col REGEXP '[a-z]{2}[A-Z]'
select * from table where binary(your_field) regexp '^[a-z]{2,}[A-Z]+'
精彩评论