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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l