How to select records from mySQL whose field value is contained at the beginning of a row?

Question

MySQL

There is a table in which the field "field" is equal to:

• abc
  
• def
  
• ghk
  
• abcdef
  
• defghk
  

There is a string "abcdefghk"
You need to make a query that will select the following records:

• abc
  
• abcdef
  

that is, which match the beginning of the string "abcdefghk"
UPD: Generally speaking, the field value must be contained at the beginning of the string.
The field values ​​and the string can be anything. Here I just gave an abstract example.

Answer 1

He asked himself, answered himself =) While explaining to Sasha Pushkarev what his mistake was, he solved the question himself. Doubts are only about the optimality of such a request
Answer:

SELECT * FROM test WHERE field = LEFT('abcdefghk',LENGTH(field));

Answer 2

SELECT ...
FROM ...
WHERE field REGEXP '^abc(.*?)$'