PDA

View Full Version : Taglist Query Assistance


paul41598
03-14-2010, 01:15 PM
Can anyone help me with a query I want to run? I want to select all threads that have tags greater than 4?

I'm missing something big here, but my idea generally is:

select count(taglist) threadid, title FROM thread where taglist < 4

Just not sure if I need some sort of explode or something since theres comma's in the taglist field of the database

Marco van Herwaarden
03-15-2010, 10:52 AM
What are you looking for? Threads with more then 4 tags, or threads with tags that are more then 4 characters long?

paul41598
03-15-2010, 11:35 AM
Threads with more then 4 tags ;)