[ _owl_ @ 26.10.2001. 17:56 ] @
Pozdrav

Imam sledeci problem:
U tabeli imam neku TEXT kolonu i zelim da sve redove pretrazim i pronadjem samo one u kojima se pojavljuje odredjena rec kao sama rec a ne kao deo neke druge reci.


Evo i primer

mysql> SELECT "Why this does not work" LIKE "work";
+--------------------------------------+
| "Why this does not work" LIKE "work" |
+--------------------------------------+
| 0 |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT "Why this does not work" LIKE "%work";
+---------------------------------------+
| "Why this does not work" LIKE "%work" |
+---------------------------------------+
| 1 |
+---------------------------------------+
1 row in set (0.00 sec)



[ Gojko Vujovic @ 26.10.2001. 18:29 ] @
Code:
mysql> SELECT "Ovde je rec samostalna i select vraca rezultat" REGEXP "[[:<:]]rec[[:>:]]";
+-----------------------------------------------------------------------------+
| "Ovde je rec samostalna i select vraca rezultat" REGEXP "[[:<:]]rec[[:>:]]" |
+-----------------------------------------------------------------------------+
|                                                                           1 |
+-----------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> SELECT "Ovde je recspojena sa drugom i nista se ne vraca" REGEXP "[[:<:]]rec[[:>:]]";
+-------------------------------------------------------------------------------+
| "Ovde je recspojena sa drugom i nista se ne vraca" REGEXP "[[:<:]]rec[[:>:]]" |
+-------------------------------------------------------------------------------+
|                                                                             0 |
+-------------------------------------------------------------------------------+
[ _owl_ @ 26.10.2001. 18:40 ] @
Gojko brzi si i od MySQL mailing liste.
Mnogo si mi pomogao - moracu da sednem i procesljam regexp-e