Re: the best way compare String

[Reindl Harald]

Am 04.12.2011 20:25, schrieb Rafael Valenzuela:
> Hi all,
> In one query,  I am comparing a string with a 'like=%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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc