在mysql中搜索电话号码

CREATE TABLE phone_numbers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(20),
    name VARCHAR(50)
);

INSERT INTO phone_numbers (phone_number, name) VALUES ('123-456-7890', 'John Doe');
INSERT INTO phone_numbers (phone_number, name) VALUES ('555-555-5555', 'Jane Smith');
INSERT INTO phone_numbers (phone_number, name) VALUES ('987-654-3210', 'Bob Johnson');

ALTER TABLE phone_numbers ADD FULLTEXT(phone_number);

SELECT * FROM phone_numbers WHERE MATCH(phone_number) AGAINST('123-456-7890' IN BOOLEAN MODE);