code_junkie

Hierarchical tagging in SQL

Nov 12th, 2011
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. tag path
  2. --- ----
  3. database database/
  4. mysql database/mysql/
  5. mysql4 database/mysql/mysql4/
  6. mysql4-1 database/mysql/mysql4-1/
  7. oracle database/oracle/
  8. sqlserver database/sqlserver/
  9. sqlserver2005 database/sqlserver/sqlserver2005/
  10. sqlserver2005 database/sqlserver/sqlserver2008/
  11.  
  12. SELECT * FROM tags WHERE path LIKE 'database/%'
Add Comment
Please, Sign In to add comment