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: http://dev.mysql.com/doc/mysql/en/packet-too-large.html String functions should help you: http://dev.mysql.com/doc/mysql/en/string-functions.html Gregory Machin <[EMAIL PROTECTED]> wrote: > 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 I=20 > 1 import all the pages in one directory into the column. > 2 how do i do a search and replace the tags with the new correct ones ? > > Many thanks ... > > > --=20 > Gregory Machin > [EMAIL PROTECTED] > [EMAIL PROTECTED] > www.linuxpro.co.za > Web Hosting Solutions > Scalable Linux Solutions=20 > www.iberry.info (support and admin) > www.goeducation (support and admin) > +27 72 524 8096 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]