Selecting multiple mysql columns

Question

I cannot figure out how to select multiple columns and a comma separated column.

I have:

Table: example_tbl
| amount   | recurring | frequency    |
| 100      | 150       |  8,monthly   |
| 200      | 250       |  1,annually  |

The problem seems to be with the frequency and the comma. I tried:

$q = mysql_query("SELECT amount, recurring FROM example_tbl WHERE id=".$item['relid']." LIMIT 1" AND * FROM example_tbl WHERE FIND_IN_SET ('monthly', frequency));

Any help would be appreciated.

What is it you want to select?

Étienne Miret
– Étienne Miret

2013-10-04 16:37:48 +00:00
Commented Oct 4, 2013 at 16:37 — Étienne Miret
– Étienne Miret, Commented Oct 4, 2013 at 16:37

Barmar · Accepted Answer · 2013-10-04 16:38:18Z

1

The problem has nothing to do with the comma, your SQL syntax is just wrong. Connect all the conditions in a single WHERE clause using AND.

$q = mysql_query("SELECT amount, recurring, frequency
                  FROM example_tbl
                  WHERE id=".$item['relid']."
                    AND FIND_IN_SET ('monthly', frequency)
                  LIMIT 1");

answered Oct 4, 2013 at 16:38

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mauzer Over a year ago

Is it valid to specify more than once FIND_IN_SET, like: AND FIND_IN_SET ('monthly', frequency) AND FIND_IN_SET ('annually', frequency)

Barmar Over a year ago

Sure. They're just expressions, you can use them like any other expression.

Collectives™ on Stack Overflow

Selecting multiple mysql columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related