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)
Owl