What is the easiest way to implement this SQL query?

Question

SQL

Good evening,
there is a column containing phone numbers, you need to select a number knowing only a few digits. For example, find all numbers containing this mask: +7986 XXXXX 20.

SELECT* FROM numbers WHERE number LIKE '+7986 можно так реализовать ? 20';

Answer 1

It's all right?

SELECT * FROM `phones` WHERE `number` LIKE '+7986%20'

Those. put % instead of unknown numbers

Answer 2

+7986_____20