Hi I have doubt what to use to store the following: 1. If I have html data eg. <html><body>my long data are here which include more html tags</html> etc... Now, I would like this is stored as what it is and would like to do query like searching for specific word or words. Which is the best field type to use ? "Text" or "BLOB" or etc.. 2. If I stored the above as BLOB can I query the field for the contains ? 3. If I stored the MS Words file in BLOB can I run any query to retrieve the contain of the files ?
Thankx Please take note: This is to inform that, we have changed our email domain to "normah.com". The email identification (email ID) remains unchanged. Eg. Old email address "[EMAIL PROTECTED]" New email address "[EMAIL PROTECTED]" Please update your address book accordingly. Thank you. Mail Administrator Normah Medical Specialist Centre Lot 937, Section 30 KTLD Jalan Tun Abdul Rahman , Petra Jaya, 93050 Kuching, Sarawak, Malaysia. Telephone line: +60 82 440055 Fax line: +60 82 442600 Email : [EMAIL PROTECTED] This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Normah Medical Specialist Centre . If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify [EMAIL PROTECTED] --------------------------------------------------------------------- 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