I have a php script which basically has a select statement, something along the lines of:
select * FROM TABLE x WHERE Name LIKE '%$variable%'
$variable is a passed variable from an input text field.
This works great IF the text being searched is in that order, so if the name field contains:
John William Smith
and I search for John William - it returns the record, but not if I search for:
John Smith, or Smith William
How can this be achieved?
Many thanks for your help.