Search first and last word of a record

Question

I have a snippet of the code that picks up and the first and last user name of a table and stores in another table. For example.:

Table users: Carlos Drummond de Andrade

Picked up Carlos Andrade and stored in another table.: Table selected users

The system has an internal search from which it searches the first table users, but how would I make this search accurate, having in the client’s view only the first and last name? I tried to use LIKE.:

$sql = mysqli_query($conexao,"SELECT * FROM tab_usuarios WHERE NomeUsuarios LIKE '%".$nomeBusca."%' ");

But it didn’t work!

Answer 1

If you want to get users who have the same first and last name, separate the string sought and seek every part of the name.

Example:

$nome = "Carlos Andrade";
$nome = explode(" ",$nome);
$primeiroNome = $nome[0];
$ultimoNome = $nome[1];
$sql = mysqli_query($conexao,"SELECT * FROM tab_usuarios WHERE NomeUsuarios LIKE '{$primeiroNome}%'  AND  LIKE '%{$ultimoNome}'");

This way your search will return all users who have the first name Carlos and the last name Andade.