Re: use of regex in mysql

On 18-02-17 16:42, The Natural Philosopher wrote:
> On 18/02/17 15:12, J�rgen Exner wrote:
>> On Thu, 16 Feb 2017 20:29:12 -0800 (PST), kushal bhattacharya
>> <bhattacharya.kushal4_at_gmail.com> wrote in comp.databases.mysql:
>>
>>> please tell me how to do that
>>
>> The gereral pattern would be
>>
>> SELECT foo
>> FROM bar
>> WHERE foo.sometext REGEXP 'YourRegExp'
>>
>> Because your are not providing any context or further information it is
>> impossible to give a more specific answer to your generic question.
>>
>> jue
>>
> Hang on Jürgen, its not good form to actually answer the posted question
> simply and concisely, if at all!
>
>

It's also not smart to ask a question if the answer is in the docs ... https://dev.mysql.com/doc/refman/5.7/en/regexp.html#operator_regexp (and Jürgen just gave the hint on the location in the docs, near the word 'REGEXP')

Or, if one does still not understand how to do this, to leave out how they tried themselves to find the correct answer. Received on Sun Feb 19 2017 - 15:14:20 CET