Regex in MySql database

Question

sorry for my English.
Please help with pregex in MySql. I want to find two words in text. Between this words can be one or more spaces and/or punctuation mark.
For example:

Tree, apple
Tree   ,   apple
Tree     ,apple
Tree   ,apple
Tree,apple

Thanks you!

Welcome to SO... What did you try ? and what result did you get ? — Enissay
– Enissay, Commented Jan 7, 2014 at 14:42

Drew Noel · Accepted Answer · 2014-01-07 16:12:08Z

2

MySQL natively supports RegEx since 5.1. Are you looking for something like:

SELECT * FROM `mytable` WHERE `mycol` REGEXP '[[:alpha:]]+[ ,.]*[[:alpha:]]+'

For more information, check out the MySQL Documentation

edited Jan 7, 2014 at 16:12

answered Jan 7, 2014 at 14:43

Drew Noel

861 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

atomman Over a year ago

Given the examples in the post I would presume you should use alpha instead of alnum. It is also worth noting that RLIKE is a synonym for REGEXP and could be used as well, although I prefer REGEXP as the name better highlight the functionality of the operator.

Collectives™ on Stack Overflow

Regex in MySql database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related