On Sun, 24 Apr 2005, Maximilian Gerlach wrote:
> Nimm einen Platzhalter. Also nicht 'air', sondern '%air%' (iirc)
>
> Gehts?
mysql> select url,left(dump,10) as dump from suche where MATCH dump
AGAINST ('%air%' IN BOOLEAN MODE) limit 1;
Empty set (0.00 sec)
leider nein!
so sieht die table aus:
mysql> desc suche;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| url | varchar(128) | | | | |
| title | varchar(128) | | | | |
| dump | text | | MUL | | |
| time | int(15) | | | 0 | |
+-------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
Gruss
--
http://skygui.de/ ICQ: 304 760 315
--
----------------------------------------------------------------------------
PUG - Penguin User Group Wiesbaden - http://www.pug.org
