Last active
December 11, 2015 16:49
-
-
Save jblac/4630622 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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