Posted for "De Q. Vo" <[EMAIL PROTECTED]>, who can't post to the list because the list cop program doesn't like the netzero trailer: Hello, Is there an INDIRECT data type which can fetch and store data directly from a file system? I wanted to build a dynamic web site with contents derived from a mysql database. Say, if I have a table defined as such create table webtbl (fileid int(3) unsigned not null auto_increment primary key, contents blob); insert into webtbl values (NULL,"/home/www/file1.htm"), (NULL,"/home/www/file2.htm"), (NULL,"/home/www/file3.txt"), (NULL,"/home/www/somefile.pdf"); this way, the contents field contains only the file name [which is non-desirable and it was not originally intended]. I would like to load the contents of a file into the contents field so that it can be searchable (e.g., select fileid from webtbl where substr(contents,1,200) like "%search_string%") Texis SQL of Thunderstone has an INDIRECT data type for this purpose. I wonder if MySQL has a similar functionality that I'm not aware of. Has anyone been using MySQL for web publishing? How would one create a table to hold contents of a file such as above? ps. a file can be quite large ~ 500K Thank you! De --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
