Perhaps the opposite is LIKE% ...%?

Question

In short, I want the vocabulary to match a line of text, but it should not match the entire line, only at the beginning. So this is actually a kind of reverse LIKE% ...%

For instance,

SELECT * FROM `dictionary` WHERE
    (`simplified` = '铅笔的历史非常悠久，它起源于2000多年'
    OR `simplified` = '铅笔的历史非常悠久，它起源于2000多'
    OR `simplified` = '铅笔的历史非常悠久，它起源于2000'
    OR `simplified` = '铅笔的历史非常悠久，它起源于200'
    OR `simplified` = '铅笔的历史非常悠久，它起源于20'
    OR `simplified` = '铅笔的历史非常悠久，它起源于2'
    OR `simplified` = '铅笔的历史非常悠久，它起源于'
    OR `simplified` = '铅笔的历史非常悠久，它起源'
    OR `simplified` = '铅笔的历史非常悠久，它起'
    OR `simplified` = '铅笔的历史非常悠久，它'
    OR `simplified` = '铅笔的历史非常悠久，'
    OR `simplified` = '铅笔的历史非常悠久'
    OR `simplified` = '铅笔的历史非常悠'
    OR `simplified` = '铅笔的历史非常'
    OR `simplified` = '铅笔的历史非'
    OR `simplified` = '铅笔的历史'
    OR `simplified` = '铅笔的历'
    OR `simplified` = '铅笔的'
    OR `simplified` = '铅笔'
    OR `simplified` = '铅')
    ORDER BY CHAR_LENGTH(`simplified`) DESC;

It works and does what I need, but I know that it is extremely inefficient. Is there any other way to do this? Many thanks!

Examples of results:

97576   铅笔
97484   铅
97566   铅

Answer 1

What about

WHERE `simplified` = SUBSTRING(
  '铅笔的历史非常悠久，它起源于2000多年',
  0, CHAR_LENGTH(`simplified`))

? Probably not indexable, but at least the request is short. :)

And you can optimize it by adding

AND `simplified` LIKE '铅%'

reject all lines that at least do not start with the correct character.

Answer 2

try like this:

SELECT * FROM `dictionary` WHERE simplified like '铅%'

Answer 3

REGEXP .