Escapestring not escaping ^

[Ivan Smahin]

Hello jda,

Tuesday, November 1, 2005, 6:08:17 PM, you wrote:

j> Hi Ruslan,

j> I tried this LIKE search

j> select id,hit from thereferences where (allFields LIKE 'the') order by id

j> and got no hits (there should be dozens). REGEX works here. So LIKE
j> is not a substitute for REGEX for me.

Obviously you want to get something like "all records which CONTAINS
'the' word"?

So it should be:
select id,hit from thereferences where (allFields LIKE '%the%')


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua