If I use this query:
Code:
SELECT user.username FROM user AS user WHERE usergroupid IN (16,103,104,105,106) OR FIND_IN_SET(16,membergroupids) OR FIND_IN_SET(103,membergroupids) FIND_IN_SET(104,membergroupids) OR FIND_IN_SET(105,membergroupids) OR FIND_IN_SET(106,membergroupids) OR ORDER BY RAND() LIMIT 1
I get this error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIND_IN_SET(104,membergroupids) OR FIND_IN_SET(105,membergroupids) OR FIND_IN_SE' at line 1
|
Using this shortened version:
Code:
SELECT user.username FROM user AS user WHERE usergroupid IN (16,103,104,105,106) ORDER BY RAND() LIMIT 1
I get the following error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'savagesh_vBull_CMS_Prod.user' doesn't exist
|
Like I said, I'm not a programmer.

MySQL version is 5.5.52-cll if that matters any.