Brion,
Would you recommend grabbing a SearchEngine object for the purpose he
described instead? Does SearchEngine take the flags
(external/compressed) into account?
-- Jim R. Wilson (jimbojw)
On Fri, Mar 28, 2008 at 12:50 PM, Brion Vibber <brion(a)wikimedia.org> wrote:
-----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-----
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l