Posted by David Quinton on 10/20/06 06:46

On 19 Oct 2006 11:41:56 -0700, "carrajo" <carrazola@gmail.com> 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...
<http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html> refers.
HTH.
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

[Back to original message]