fields: name, description, address
name: Judo Center The Judokas
description: Dojo in the heart of the City of Paris. Also for Kids
address: Blossom Avenue 333, Paris
name: The Aikis
description: Aikido gym in brussels, Belgium. Amateur & Professional.
address: Mainstreet 44, Brussels
User searches for "Judo Center Paris", or "Aikido Brussels"
(let`s call the search "searchstring")
So far, i have come up with:
SELECT * FROM example WHERE name LIKE '%searchstring%' OR description LIKE '%searchstring%' OR address LIKE '%searchstring%'";
Obviously, this doesn`t return any of the records. Which SQL query should i use?