212 reputation
110
bio website
location
age
visits member for 3 years
seen Oct 10 at 15:51

Nov
10
awarded  Popular Question
Sep
30
awarded  Popular Question
Jul
31
awarded  Popular Question
Jul
2
awarded  Curious
Apr
27
awarded  Yearling
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