SOUNDS LIKE

Overview

Performs Soundex matching.

See also: SQL Operators in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

CREATE TABLE sounds_like_example (
  word VARCHAR(32)
);
INSERT INTO sounds_like_example VALUES
  ('Places'),
  ('Army'),
  ('Cats');
SELECT * from sounds_like_example
WHERE word SOUNDS LIKE 'play says'
   OR word SOUNDS LIKE 'arm ee';
+--------+
| word   |
+--------+
| Places |
| Army   |
+--------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES