Brent,
Both worked like a charm. Thank you so much.
I kicked myself for not thinking of CONCAT.
Yes, Filemaker joy. Actually I have another word in mind. But with
you help and expertise we are slowly walking away from Filemaker.
Erik
On Jul 14, 2006, at 7:02 AM, Brent Baisley wrote:
Aaaah the joys of importing data from FileMaker. Repeating fields,
grrrrr.
You need to do an ASCII/CHAR conversion since vertical tab is a
"non-printable" character.
select *
from accounts
where billing_address_street LIKE CONCAT("%",CHAR(11),"%")
Since this is problem a one shot deal and you are doing a full
table scan anyway, just do a search and replace on the field(s).
This will convert all vertical tabs to returns.
UPDATE accounts SET billing_address_street=REPALCE
(billing_address_street, CHAR(11), CHAR(13))
----- Original Message ----- From: "Saline Erik" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, July 13, 2006 1:17 PM
Subject: Vertical Tab problem
We recently exported data from Filemaker then imported into mySQL
4.0.22. The data shows up in mySQL queries just fine. But when
we use our PHP based Web App it shows little boxes in the data.
The little box is a Vertical Tab that Filemaker uses. The Ascii
is 11 or 0xb or sometimes known as \v.
What I am trying to do is a replace of the little boxes with a
space or something.
I can not get the query to find the records with the Vertical Tab
in it.
I tried:
select *
from accounts
where billing_address_street LIKE "%\v%"
That returns everything with the letter v in it.
Any ideas would be great.
Erik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
