What's wrong with this query?

[jda]

>
>  >
>  > SELECT id,uniqueID from thetable WHERE url REGEX
>  > 
>'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=PubMed&dopt=Cit
>>  ation&list_uids=1406972'
>  >
>>



>I remember that year ago or more
>We have remove from Valentina Escape any regex escaping...
>
>Why we did this ...
>Aha, because it is a string literal, between ''
>So parser self can extract it as monolithic thing
>
>So you say that
>
>     Url = 'xxxxx'
>
>Will find this record ?
>
>
>May be we still need escape DOTs and ?  Inside of literal..
>Jon, please try manually escape them.
>

Hi Ruslan,

This search works:

Select  id,uniqueID from thetable WHERE url REGEX 
'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?'


This fails:

Select  id,uniqueID from thetable WHERE url REGEX 
'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd'


This also fails:

Select  id,uniqueID from thetable WHERE url REGEX 
'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi\?cmd'


So it seems that nothing can come after the question mark, even if 
the question mark is escaped (am I escaping it correctly?).

Jon