Member Avatar for ultras1

Hi to All.
I have this code:

$query = " SELECT *FROM tabela WHERE persons LIKE '%$search%'

For example I have row in persons column which contains "John William Smith"
If I type in search filed "John William" or "William Smith" it will return result. But how to make to return result if I type "John Smith" in search box.

  • 3 Contributors
  • 4 Replies
  • 97 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ultras1
Member Avatar for ShawnCplus 
$search = join('%', explode(' ', $search));
/*
 For Example:
   search = 'John Smith';
   search = join('%', explode(' ', search));
   search now = John%Smith
*/
Member Avatar for network18

good logic ShawnCplus :)
short n sweet, i liked it..!!
thnx

Member Avatar for ShawnCplus

Wow, I can't believe I suggested that. That is insanely slow and stupid, sorry. Just do

$search = str_replace(' ', '%', $search);
Member Avatar for ultras1

Wow, I can't believe I suggested that. That is insanely slow and stupid, sorry. Just do

$search = str_replace(' ', '%', $search);

Perfect !

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.