Regular Expressin in MySQL ?

Hi,

I'm try to do something like:

SELECT description FROM table WHERE {regularexpression to remove all
non-word} = 'WidgetLarge02'

I have a field called description. Description contains a value like
'Widget Large?>/~-02'. The value I have on hande is WidgetLarge02.

I guess I need to replace all non-word characters first then match
against the value I have. Any way I can do this?

Re: Regular Expressin in MySQL ?

On 19 Oct 2006 11:41:56 -0700, "carrajo" wrote:

>Hi,
>
>I'm try to do something like:
>
>SELECT description FROM table WHERE {regularexpression to remove all
>non-word} = 'WidgetLarge02'
>
>I have a field called description. Description contains a value like
>'Widget Large?>/~-02'. The value I have on hande is WidgetLarge02.
>
>I guess I need to replace all non-word characters first then match
>against the value I have. Any way I can do this?

Itt looks like WHERE NOT REGEXP might do the job?
But I've never tried it...
refers.
HTH.
--
Locate your Mobile phone:
Great gifts: