I have a table with sample datas, as follows,
organization, first_name, last_name, country, date, published, hide_me
xyz, Steve, Small, Hungary, 2014-04-01, 1, 0
zxy, Rob, Big, England, 2014-04-02, 0, 0
yxz, Bob, Middle, Germany, 2014-04-03, 1, 1

I am using this query:
SELECT `organization`, `first_name`, `last_name`, `country`, date(`created_date`) FROM `jos_jd_donors` WHERE `published`=1

The result is

xyz, Steve, Small, Hungary, 2014-04-01
yxz, Bob, Middle, Germany, 2014-04-03

Help me please to create a query, when the hide_me=1, and the result should look like this one:

xyz, Steve, Small, Hungary, 2014-04-01
Anonimous, " ", " ", Germany, 2014-04-03

The name of organization should be changed to Anonimous, the names whould be empty strings. I tried to use the SELECT CASE but no success.
Best regards,
Pista

Hello,

Do you want to retrieve records where published = 1 and hide_me = 1?

Regards,
ARI Soft

I want to retrive when published=1 and hide_me=1, but if the hide_me=1 then the name of organization has to be changed to "Anonimous" and the first name and last name have to be empty.

Try the following SQL query:



Regards,
ARI Soft

I got "No data available." message.

I think I found the solution

SELECT CASE `hide_me` WHEN 1 THEN 'ANONYMOUS' ELSE `organization` END,
CASE hide_me WHEN 1 THEN '' ELSE `first_name` END,
CASE hide_me WHEN 1 THEN '' ELSE `last_name` END,
`country`,
date(`created_date`) AS date
FROM
`jos_jd_donors`
WHERE
`published`=1
ORDER BY date DESC

It seems working.