192 reputation
6
bio website
location
age
visits member for 2 years, 4 months
seen Mar 29 at 8:25

Mar
29
comment MySQL Full Text search increase relevance for exact matches?
That looks genius but doesn't work brilliantly: SELECT levenshtein("insitute doobry", "doobry institute canteen"), levenshtein("insitute doobry", "doobry institute"); Gives 15 and 15. It works well in other situations.
Jul
22
revised How to duplicate related rows
added 75 characters in body
Jul
22
comment How to duplicate related rows
Thanks for your answer. I don't understand how this could work though except in a manual loop. I'm looking for something that inserts a bunch of new payments (not just the last one) -- i.e. generating a set of new IDs -- and then the respective new Ids being used to generate the new Project records.
Jul
19
comment How to duplicate related rows
@RolandoMySQLDBA done that
Jul
19
revised How to duplicate related rows
added 861 characters in body
Jul
19
comment How to duplicate related rows
ah, sorry, should have made it clear: I'm doing this for a whole bunch of records, not just one.
Jul
19
asked How to duplicate related rows
Apr
19
answered MySQL Full Text search increase relevance for exact matches?
Apr
19
asked MySQL Full Text search increase relevance for exact matches?
Feb
28
comment How do I update last row of a group in MySQL
The question is specifically about MySQL (hence title, tag), it is a known limitation of MySQL. Thanks anyway.
Feb
27
comment How do I update last row of a group in MySQL
Thank you! That's perfect.
Feb
27
comment How do I update last row of a group in MySQL
Nope, this generates the same error.
Feb
27
comment How do I update last row of a group in MySQL
Thank you. This works well when there are not two records with the same MAX(date). Let's say that's valid data, and that another field is needed to determine the latest one, e.g. sort on date, ID - is there a solution for that too? (feel free to say this is a different question if not simple!)
Feb
27
accepted How do I update last row of a group in MySQL
Feb
27
asked How do I update last row of a group in MySQL
Feb
22
accepted Optimising MySQL query with lots of self-joins
Feb
22
accepted Efficiency for contact-contact relationships schema
Dec
21
comment Efficiency for contact-contact relationships schema
I did it! See related question and thanks again.
Dec
21
revised Optimising MySQL query with lots of self-joins
added 457 characters in body
Dec
21
comment Optimising MySQL query with lots of self-joins
Thanks, I've edited first line to be clearer. But the question was about optimising the query, not just the join. And I achieved that by 20x, which is good! I'm interested with what you say to try it with a non-covering index (and to try MariaDb without that index), but I suspect the table lookup is what was causing it grief. Will report back if I do these test. Thanks for your help.