-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Daniel Barrett wrote:
Is this a correct query to find all current articles
that contain a
given string?
[snip]
WHERE
t.old_text like '%STRING%'
In a default installation, most of the time, it will work, but you can't
rely on it in general.
The value of old_text may be compressed, in an alternate encoding, or
may contain a serialized PHP object which references an external blob or
another text table entry or contains multiple text entries
batch-compressed together.
- -- brion vibber (brion @
wikimedia.org)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iEYEARECAAYFAkftL+wACgkQwRnhpk1wk44XtACgw+3Rb19hubD6/NYxIPbshfbt
nFwAoLVo8rracnop9FrfMh7w7ZgTRxlX
=UWyx
-----END PGP SIGNATURE-----