Skip to content

Instantly share code, notes, and snippets.

@joshsmith

joshsmith/search_example

Created October 2, 2010 17:44
Show Gist options
  • Save joshsmith/607823 to your computer and use it in GitHub Desktop.
Save joshsmith/607823 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search_example
mysql> SELECT * FROM interests JOIN search_table ON (interests.iid = search_table.id) WHERE query='philosophy of science;mode=any';
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+
| iid | title | body | modified | id | weight | query | group_id |
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+
| 31 | Philosophy of Science | NULL | 2010-08-01 01:36:26 | 31 | 6 | philosophy of science;mode=any | 0 |
| 30 | Philosophy | NULL | 2010-08-01 01:36:22 | 30 | 1 | philosophy of science;mode=any | 0 |
| 32 | Philosophy of Math | NULL | 2010-08-01 01:36:30 | 32 | 1 | philosophy of science;mode=any | 0 |
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment