REGEX and ?

[Ruslan Zasukhin]

On 19/4/07 11:51 PM, "jda" <jda at his.com> wrote:

>>> I thought this used to work for finding a question mark:
>> 
>> this query works for me
>> 
>> select * from oc_report where memo_text like '%?%'
>> 
>> But of course this style is really not the fastest way, so perhaps
>> Ruslan can speed things up, but until the above should do the job
>> 
> 
> Hi Thorsten,
> 
> Thanks for the suggestion. But that search doesn't work for me, for
> example, if ? is at the end of a sentence.
> 
> But actually I have been using REGEX for a generalizable
> search/replace function for a long time, and I'm pretty sure the
> REGEX code I posted used to work. I see it doesn't work now (nor does
> a similar search for *, with or without escaping).

What about 

SELECT * FROM myTable WHERE title REGEX '.*\?.*'


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]