Re: String manipulation and RIGHT() Problem

[Jay Pipes]

Why are you reinventing the wheel like this? Why not just use LOAD DATA INFILE, passing in a line terminator of '@' and a field terminator of '|'? Seems like a lot of effort for functionality that is already in MySQL?

Something like:

LOAD DATA INFILE 'sometext.txt'
INTO my_table
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '@';

SELECT * FROM my_table;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com