fork(2) download
copy 
  1. <?php
  2. $search = "tes hello hey wha";
  3. $search_exploded = explode(" ", $search);
  4.  
  5. $construct = "SELECT * FROM Leads WHERE keywords LIKE ";
  6. $construct .= "'%".implode("%' AND '%", $search_exploded)."%'";
  7.  
  8. print $construct;
  9.  
  10.  
Success #stdin #stdout 0.01s 20568KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT * FROM Leads WHERE keywords LIKE '%tes%' AND '%hello%' AND '%hey%' AND '%wha%'
https://ideone.com/XxaHAh
language:
PHP (php 7.3.5)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!