*nods*
Point of interest: vBulletin only supports MySQL, IPB supports MySQL with MSSQL as a paid plugin (though knowing how that handles queries, it's not impossible to make it support other DBs without too much work)
Yeah, FIND_IN_SET is ridiculous, and doubly so since in PGSQL's case it doesn't exist at all, and has to be shoe-horned in as a user function (at a performance penalty, too), which returns T or F (or t or f sometimes), so you end up having to rewrite every instance of FIND_IN_SET in queries. I mean, seriously... who does it like that?
* Arantor hands Nao the axe to finish chopping the multi DB code out.
Point of interest: vBulletin only supports MySQL, IPB supports MySQL with MSSQL as a paid plugin (though knowing how that handles queries, it's not impossible to make it support other DBs without too much work)
Yeah, FIND_IN_SET is ridiculous, and doubly so since in PGSQL's case it doesn't exist at all, and has to be shoe-horned in as a user function (at a performance penalty, too), which returns T or F (or t or f sometimes), so you end up having to rewrite every instance of FIND_IN_SET in queries. I mean, seriously... who does it like that?