From: Reindl Harald
Date: December 4 2011 7:33pm
Subject: Re: the best way compare String
List-Archive: http://lists.mysql.com/mysql/226441
Message-Id: <4EDBCAF3.4030506@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig131CA56C4C5445D28A2F61D8"

--------------enig131CA56C4C5445D28A2F61D8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 04.12.2011 20:25, schrieb Rafael Valenzuela:
> Hi all,
> In one query,  I am comparing a string with a 'like=3D%patron%', but is=
 very
> slow and expensive .What is the best way to compare a string? like or
> regular expression?
> The data base is too big table 1TB, any idea?
> thanks a lot

http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

without indexes is big tables is no fast search possible
if you are useing innodb you have currently lost


--------------enig131CA56C4C5445D28A2F61D8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7byvMACgkQhmBjz394Anm8gACfdlgT9hCb6ZQv3Ttr3/7DxcI2
bzAAn1ikuo4jJUuHyw82gVyU+q1LAefI
=F5yd
-----END PGP SIGNATURE-----

--------------enig131CA56C4C5445D28A2F61D8--