Suppose I have 400 lines of names of people in a database. What is the best way to search for their names?

Question

They will also search for part of their name. Not just words with spaces. If they type Matt, I also expect to get Matthew.

Answer 1

SELECT * 
FROM mytable 
WHERE name LIKE 'matt%' OR name LIKE '[ ,-/]matt%'

:
1) . , LIKE "% xyz%", , xyz . , " " "".
, . [^A-Z0-9] ( O'Brian brian, , , ...)

2) .. , , , . !
( 30 ), name. - , , , , ..
, SELECT * myTable [ "" ], , .
, , 50 000 (, , "" 40 ), : "" .

3) . , , , ( / ), .
, ( , , ..). , , - Soundex Soundex , , (, Wilmson vs. Wilmsen vs. Willmsonn ...)

Answer 2

:

SELECT * 
 FROM mytable 
WHERE name LIKE '%matt%'

Answer 3

:

• (FTS)
• Regular expressions
• LIKE Using wildcards

... in that order of preference.

Answer 4

If you are trying to find names through any development language, you can use the regular expression package in Java. Some things like java.util.regex. *;