From: Brent Baisley
Date: April 5 2005 3:46pm
Subject: Re: Line Breaks Problem (\r\n) in Query
List-Archive: http://lists.mysql.com/mysql/182178
Message-Id: <923a8f43dd7e46729c8327ae040c6fe5@landover.com>
MIME-Version: 1.0 (Apple Message framework v619.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-Transfer-Encoding: 7bit

I'm not sure what may have changed, but what you are searching on is  
really a partial value of a field. You wouldn't normally think of \r\n  
as characters, but they are are, just like a or b.
Whenever you are searching  on a partial value, you should use LIKE and  
%.
SELECT * FROM table_name WHERE column_name LIKE 'value%';

You won't have to change any of your indexes or table structures, your  
indexes will still be used for a fast search.

On Apr 5, 2005, at 9:18 AM, bidochko@stripped wrote:

> Hello,
>   I recall this problem again. No answer still. If I need to talk to
>   other list(probably internals) just let me know.
>
>   -----------------------------------------------------------------
>   I would like to describe the following problem and get an opinion
>   from list members.
>
>   I have simple table like
>   describe table_name;
>    
> +---------------------+------------------+------+-----+--------- 
> +----------------+
>   | Field               | Type             | Null | Key | Default |  
> Extra          |
>    
> +---------------------+------------------+------+-----+--------- 
> +----------------+
>   | table_name_id       | int(10) unsigned |      | PRI | NULL    |  
> auto_increment |
>   | column_name         | varchar(30)      |      |     |         |     
>             |
>    
> +---------------------+------------------+------+-----+--------- 
> +----------------+
>
>   My table values contains line breaks ('\r\n').
>   For example I have 1 row with 'value\r\n' in 'column_name'.
>
>   SELECT HEX(column_name)FROM table_name;
>   will return
>   76616C75650D0A
>
>   I'm running the following query (I want to get records and DO NOT
>   use '\r\n' im my WHERE clause)
>   SELECT * FROM table_name WHERE column_name='value';
>
>   On MySQL Ver 11.18 Distrib 3.23.55 that query returns 1 row,
>   on MySQL Ver 14.7 Distrib 4.1.9 empty set is return.
>
>   I did not found anything in change log files about that difference.
>
>   So, I wonder if behavior of newer MySQL version is feature or bug or
>   bug fix. What is correct?
>
>   Thanks!
>
> -- 
> Andrew Bidochko
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:     
> http://lists.mysql.com/mysql?unsub=brent@stripped
>
>
-- 
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577