Re: Re search and replace in large text fields

2005-07-27 Thread Gleb Paharenko
Hello. Use TEXT or BLOB columns' types. See: http://dev.mysql.com/doc/mysql/en/blob.html Use hexademical values in your scripts which load pages in the database. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html Possibly you'll need to increase packet size. See: h

RE: Re search and replace in large text fields

2005-07-21 Thread Jay Blanchard
[snip] Please could you advise me my MySql, is a bit shacky. I need to capture about 700 web pages to a large text column in my database, the search for all the links in the pages within the column and replace them with new relative links .. to the pages now stored in the data base .. so how do I

Re search and replace in large text fields

2005-07-21 Thread Gregory Machin
Hi all... Please could you advise me my MySql, is a bit shacky. I need to capture about 700 web pages to a large text column in my database, the search for all the links in the pages within the column and replace them with new relative links .. to the pages now stored in the data base .. so how do