Created
December 28, 2018 21:20
-
-
Save sareiodata/69e7baa8b9c60c8db01900818d63324a to your computer and use it in GitHub Desktop.
Possible solution for similar string search
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM `wp_trp_dictionary_en_us_ro_ro` WHERE | |
MATCH original AGAINST( '“That is why, I suppose, you wished him to go on to Bukovina. You cannot | |
deceive me, my friend; I know too much, and my horses are swift.” As he | |
spoke he smiled, and the lamplight fell on a hard-looking mouth, with | |
very red lips and sharp-looking teeth, as white as ivory. One of my | |
companions whispered to another the line from Burger’s “Lenore”:—' ) | |
AND | |
( CHAR_LENGTH('“That is why, I suppose, you wished him to go on to Bukovina. You cannot | |
deceive me, my friend; I know too much, and my horses are swift.” As he | |
spoke he smiled, and the lamplight fell on a hard-looking mouth, with | |
very red lips and sharp-looking teeth, as white as ivory. One of my | |
companions whispered to another the line from Burger’s “Lenore”:—') - 10 ) < CHAR_LENGTH( original ) | |
AND | |
CHAR_LENGTH( original ) < ( CHAR_LENGTH('“That is why, I suppose, you wished him to go on to Bukovina. You cannot | |
deceive me, my friend; I know too much, and my horses are swift.” As he | |
spoke he smiled, and the lamplight fell on a hard-looking mouth, with | |
very red lips and sharp-looking teeth, as white as ivory. One of my | |
companions whispered to another the line from Burger’s “Lenore”:—') + 10 ) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
https://www.digitalocean.com/community/tutorials/how-to-improve-database-searches-with-full-text-search-in-mysql-5-6-on-ubuntu-16-04