Skip to content

Instantly share code, notes, and snippets.

@jblac
Last active December 11, 2015 16:49
Show Gist options
  • Save jblac/4630622 to your computer and use it in GitHub Desktop.
Save jblac/4630622 to your computer and use it in GitHub Desktop.
<?php
$sql = "SELECT o.name AS objects_name, o.desc AS objects_desc FROM objects AS o WHERE MATCH(o.name, o.desc) AGAINST ('tak')
UNION ALL(SELECT c.name AS communes_about, c.about AS communes_about WHERE MATCH (c.name, c.about) AGAINST ('tak'))
UNION ALL(SELECT d.name AS district_name, d.about AS district_about FROM district AS d WHERE MATCH (d.name, d.about) AGAINST ('tak'))";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment