A procedure MODIFIES SQL DATA if all the modifying involves a temporary table,
or only READS SQL DATA?
Does it matter whether the temporary table is meant to outlast the
procedure-call?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
For the best chance to have a efficient query you would need to loose the
leading "%" if possible.
If you could then the query can optimize using a index.
On Sun, Dec 4, 2011 at 2:50 PM, Reindl Harald wrote:
> you THINK the engine is? WTF?
>
> fulltext if you need fulltext-search
> please read th
;>>> 2011/12/04 20:25 +0100, Rafael Valenzuela
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?
Any decent implementation
Thank you so much, i'll try to do this and, so sorry for any inconvenience
2011/12/5 Andrés Tello
>
> I use the soundex algorithm to generate a 4 characters fingerprint of the
> phonetic sound of a string, then I create an index over that field and
> serch for it.
>
>
> But soundex has an "iss
Taking the question _very_ literal:
> A quick guess, or at least a starting point:
>
> SELECT key, data
, SUBSTRING_INDEX(GROUP_CONCAT(data ORDER BY data SEPARATOR ','),',',2)
> FROM myTable
> GROUP BY key
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
