CODEWITHSUNDEEP
mysqlselect
Paweł Adamczyk
Paweł Adamczyk

Reputation: 253

Finding small letter between two capital letters - MySQL

I've got problem - I need to find every single phrase like AbC (small b, between two Capital letters). For Example a statement: Little John had a ProBlEm and need to know how to do tHiS.

I need to select ProBlEm and tHiS (you see, BlE and HiS, one small letter in between two capital). How can I select this?

Upvotes: 5

Views: 452

Answers (2)

Prahalad Gaggar
Prahalad Gaggar

Reputation: 11599

Firstly you have split the String. Please refer this SO Question

and then search each retrive word like

substring(word,2) LIKE '[A-Z]' COLLATE latin1_general_cs

Upvotes: 0

eggyal
eggyal

Reputation: 125865

In MySQL you can use a binary (to ensure case sensitivity) regular expression to filter for those records that contain such a pattern:

WHERE my_column REGEXP BINARY '[[:upper:]][[:lower:]][[:upper:]]'

However, it is not so straightforward to extract the substrings which match such a pattern from within MySQL. One can use a UDF, e.g. lib_mysqludf_preg, but it's probably a task more suited to being performed within your application layer. In either case, regular expressions can again help to simplify this task.

Upvotes: 1

Related Questions