In the last episode (Jun 07), [EMAIL PROTECTED] said:
> It looks like mySQL is funny about a + next to a - in a string.
>
>
> If I do select count(*) from Table where Column like '%+---%'
> I get 0 records.
> If I do select count(*) from Table where Column like '%---%'
> I get 70652 records.
>
It looks like mySQL is funny about a + next to a - in a string.
If I do select count(*) from Table where Column like '%+---%'
I get 0 records.
If I do select count(*) from Table where Column like '%---%'
I get 70652 records.
How can I make it insensitive to a +-
Thanks in advance.
Piyush.