Using the mysql soundex function with parameter like

Navigation
1

How can I use the mysql soundex function as a parameter like

for example I have a people table with the name Poliana Mendes Silva

I want to search with soundex all the "polianas" of the bank ignoring the rest of the name

    
asked by anonymous 05.08.2016 / 05:59

2 answers

0

I was able to solve this problem

"SELECT * FROM Customers WHERE SOUNDEX (SUBSTRING_INDEX (COMPLETE_NAME, '', 1)) = SOUNDEX ('PAULA') AND SUBSTRING_INDEX (COMPLETE_NAME, '', -1) = '     

11.08.2016 / 00:58
-1

You can try this: 

select * from clientes
where (soundex(nome) LIKE concat('%',soundex('POLIANA'),'%'))
    
05.08.2016 / 14:51
Access an element of a JSON dynamically How to avoid repetition?