Skip to content

Instantly share code, notes, and snippets.

@sareiodata
Created December 28, 2018 21:20
Show Gist options
  • Save sareiodata/69e7baa8b9c60c8db01900818d63324a to your computer and use it in GitHub Desktop.
Save sareiodata/69e7baa8b9c60c8db01900818d63324a to your computer and use it in GitHub Desktop.
Possible solution for similar string search
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 )