hello
i have downloaded a whole html site (
http://scoach.ch/DEU/Factsheet/Tracker_Certificates/CH0030157801 ) and stored the file into a text column via LOAD_FILE. next i tryed to select some html elements but i am not even able to get the title.
mysql> select length(html), ExtractValue(html, '/html/head/title') from static_h
tml where html is not null limit 1;
+--------------+----------------------------------------+
| length(html) | ExtractValue(html, '/html/head/title') |
+--------------+----------------------------------------+
| 63453 | NULL |
+--------------+----------------------------------------+
1 row in set, 1 warning (0.00 sec)
mysql> select instr(html,'<title>') from static_html where html is not null limi
t 1;
+-----------------------+
| instr(html,'<title>') |
+-----------------------+
| 972 |
+-----------------------+
1 row in set (0.00 sec)
can anyone tell me what i am doing wrong? i am using mysql Ver 14.14 Distrib 5.1.41, for Win64 (unknown)
thx
christian