sql recordset syntax for IF THEN ELSE

[hconnorjr]

here's what i'm trying to do: i'm trying to display two different levels of content depending on whether a user pays or not. for example, if field xyz_paying = 'yes' then select *, else display only some of the fields, so i'm trying to use a mysql statement to create a SELECT filter. i've been trying to do this IF, THEN, ELSE, but i'm getting syntax error messages. could someone show me a simple example please. or suggest a good resource. thanks.

[hconnorjr · Accepted solution]

i can't seem to get the sql to do what i want, so i changed gears and i'm going to use a conditional region to display only when my paying field = = y. works fine.

i guess this is just as good as forcing the sql to do what you want. now i'm pulling all the data from the tables but displaying it only selectively.