[thelist] Proper mysql datastructure for a fullt
r937
rudy at r937.com
Mon Jan 25 12:28:21 CST 2010
travis, there are so many ideas wrapped up in your one simple post, i don't
know where to begin... ;o)
first, it is apparent that you want multiple tags per title
thus, your table design needs to change, to incorporate a tags-to-titles
table for the many-to-many relationship
as for fulltext searching, you are putting the cart before the horse if you
want tags included, as tags are atomic values, not descriptive text
fulltext search is appropriate only on title and/or descr
luckily, mysql allows fulltext indexes only on individual tables, not joined
tables, so you can't include tags after all
i realize this explanation was brief, let me know if you want any of it
expanded...
More information about the thelist
mailing list