Re: Problem in using text searching

[Vikram Malhotra]

Yes Eric, you are right. It matches both the records. And I should use a regex. But that's what my question what kind of regex supports this in mysql?

If I have to use programming instead then it doesnt make sense to use a query like this in first place.

Eric Dub Wrote:
-------------------------------------------------------
> your search actually matches both records:
> Your search
> %%image%%
>
> in the first record,the parts specified bracketed,
> the rest covered in the % wildcard...
> []hello world<>1
> how are you[]
>
> You should probably use a regex for this.
> Eric