check if row has a particular value (perl,mysql)

Question

I'm trying to identify if a row has the value '1' anywhere in it (AKA any column). Is there an easy way to do this without searching every column with fetchrow_array? I've included a small table I've been working with as an example.

mysql> select * from Case_Tracking;
+--------------------+---------+---------+----------+---------+----------+---------------+
| accession_number   | cyp2d6  | cyp2c19 | factorII | factorV | apoe     | vkorc1_cyp2c9 |
+--------------------+---------+---------+----------+---------+----------+---------------+
| AIB14-1116-0000453 | Luminex | Luminex | Hologic  |       1 | ABI 7500 | Genmark       |
| AIB14-1123-0000074 | NULL    | Luminex | Hologic  | Hologic | ABI 7500 | Genmark       |
+--------------------+---------+---------+----------+---------+----------+---------------+

ikegami · Accepted Answer · 2014-05-07 14:14:38Z

2

It would be better to search every column using SQL (WHERE accession_number = '1' OR cyp2d6 = '1' OR ...) since you'd only need to fetch matching results.

answered May 7, 2014 at 14:14

ikegami

391k17 gold badges291 silver badges555 bronze badges

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

1 Comment

user1807271 Over a year ago

Thanks, I thought maybe I was missing some sort of magical function, but it seems I have to look at each column.

Collectives™ on Stack Overflow

check if row has a particular value (perl,mysql)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related