faqts : Computers : Programming : Languages : PHP : Database Backed Sites : General : BLOBs (Binary Large Objects)

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

12 of 24 people (50%) answered Yes
Recently 5 of 10 people (50%) answered Yes

Entry

How do I perform a keyword search through text stored in BLOBs?

May 19th, 2000 04:32
Paul Kenneth Egell-Johnsen, Jeff Liu, Onno Benschop, http://www.mysql.com/php/manual.php3?section=Regexp


First we have to know what kind of RDBS your using. If you are using
mysql the short answer is that you can probably do a regular expression
search in the BLOB. Remember that data in a BLOB is searched case
sensitively, while text in a  TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT
(the corresponding text types to the BLOB types) are case insensitive.
(I haven't tested regexp's in MySQL).
I know that Oracle systems allows searches in the BLOBs.
If you are using a RDBS which doesn't support regexps in the BLOBs then
I suggest that you create your own system, probably by storing the
objects in some kind of a file and searching that file.