Fuhrmann
Well-known member
I have a variable which contains this name: Roberto Teixeira Alves Freitas
And in my Database I have this names:
I need to do a SQL query which selects all this variety of the name. The result have to be this:
There is a way to do that?
I already tried this:
But this query will only give me this results:
But I can get this name Alves Freitas and Roberto Teixeira. Any help?
And in my Database I have this names:
Code:
John Carpenter
Roberto Alves
Julian Magnata
Roberto Teixeira
Roberto Freitas
Teixeira Alves
Joey Ramone
Teixeira Roberto
I need to do a SQL query which selects all this variety of the name. The result have to be this:
Code:
Roberto Alves
Roberto Teixeira
Freitas Roberto
Teixeira Alves
Teixeira Roberto
Alves Freitas
There is a way to do that?
I already tried this:
Code:
SELECT Name FROM My_Table WHERE (Name LIKE '%Roberto%" OR Name LIKE '%Teixeira%") AND (Name LIKE '%Alves%" OR Name LIKE '%Freitas%")
But this query will only give me this results:
Code:
Roberto Alves
Teixeira Alves
Teieira Roberto
Freitas Roberto
But I can get this name Alves Freitas and Roberto Teixeira. Any help?