List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 21 1999 10:43pm
Subject:insert \% bug
View as plain text  
>>>>> "suopanki" == suopanki  <suopanki@stripped> writes:

>> Description:
suopanki> 	inserting backslash percent should insert only the percent sign (without
> backslash)
suopanki>         as happens with any other character
>> How-To-Repeat:
suopanki> 	insert into foo values ('\%')     -> \%
suopanki>         insert info foo values ('\a')     -> a

Hi!

No.  \% is special as this is handled by LIKE to make it possible to
search after '%' in a column:

SELECT * from table_name WHERE column LIKE '%\%%'

If MySQL would change the above string to '%%%', it wouldn't work that 
good.

Regards,
Monty
Thread
insert \% bugsuopanki21 Sep
  • insert \% bugMichael Widenius22 Sep
    • Re: insert \% bugHeikki Suopanki22 Sep
      • Re: insert \% bugMartin Ramsch22 Sep