I am working on a project in which the user's access to records is restricted based on the user's User Group. I have created a global variable $usr_sec_group, and I want to add to the WHERE clause in the SELECT statement for several applications a CASE statement that applies a different filter based on the value of $usr_sec_group. I am a relative "newbie" with regards to mySQL, and my attempts at writing such a statement haven't worked. Here is the basic logic:
SELECT field1, field2, etc FROM Organizations CASE $user_sec_group WHEN 1 THEN 'filter_statement_1' WHEN 2 THEN 'filter_statement_2' WHEN 3 THEN 'filter_statement_3' ELSE 'filter_statement_else' END CASE ORDER By field1
The 'filter_statements' could be any valid filter, such as
'oName => 'a' AND oName < 'g'
I am assuming that the problem is a relatively simple matter of syntax, but so far I haven't been able to write a CASE statement that works.
I will be grateful for some guidance!