How to limit amount of records in a double table with a function mysql query

Asked Sep 21 '14 at 04:46

Active Sep 21 '14 at 04:55

Viewed 48 times

What is the correct way to limit the amount of records from list1: (original source)

select `List 1`.`name`, `List 2`.`name`,
       levenshtein_ratio(`List 1`.`name`, `List 2`.`name`)
FROM `List 1`, `List 2`

The following gives 0 as result:

select `List 1`.`name`, `List 2`.`name`,
       levenshtein_ratio(`List 1`.`name`, `List 2`.`name`)
FROM `List 1`, `List 2`
LIMIT 0 , 15500

edited Sep 21 '14 at 04:55

wallyk

asked Sep 21 '14 at 04:46

boboloco

That looks like the correct way ([manual page for SELECT](http://dev.mysql.com/doc/refman/5.6/en/select.html)) to get up to the first 15,500 records. What is the field structure of the result? – wallyk Sep 21 '14 at 04:59
there is no field structure, the result is only: "0" – boboloco Sep 21 '14 at 05:12
How many records are in `List 1` and `List 2`? – wallyk Sep 21 '14 at 05:23
I tried LIMIT 50000 , 100000 ; and the result is still the same. – boboloco Sep 21 '14 at 05:24
~0.7million records in each list. – boboloco Sep 21 '14 at 05:25

0 Answers0