dynamic mysql query specific value

Question

i have below table

Overs    TargetRuns   0%    10 %    20 %    
10.0    15.6          8.7   11.9    20
10.1    15.9          8.9   12.1    20
10.2    16              9   12.2    20
10.3    16.1            9   12.3    20
10.4    16.3          9.1   12.4    20

my query is

SELECT * 
FROM target_table 
where 0% OR 10% OR 20% = '${wickets}' AND Overs = '${overs}'`

for overs 10.1 and 10% === 12.1 i need output as 12.1.

Overs TargetRuns 0% 10 % 20 % 10.0 15.6 8.7 11.9 20 10.1 15.9 8.9 12.1 20 10.2 16 9 12.2 20 i want output as for overs 10.1 and 10%== 12.1 output===12.1 — user8586565
– user8586565, Commented Jun 8, 2021 at 12:24
'i have below table' I thnk that might be your first mistake. See normalisation. — Strawberry
– Strawberry, Commented Jun 8, 2021 at 12:33
You need to quote column names which are not valid ids. Id match this regexp: [A-Z][A-Za-z0-9_]*. A name like 10% is not an id, so it must be quoted. — Doug Henderson
– Doug Henderson, Commented Jun 8, 2021 at 21:48

Akina · Accepted Answer · 2021-06-08 12:29:18Z

1

Maybe you need in

SELECT * 
FROM target_table 
WHERE '${wickets}' IN (`0%`, `10%`, `20%`)
  AND Overs = '${overs}'

?

answered Jun 8, 2021 at 12:29

Akina

43.2k6 gold badges17 silver badges30 bronze badges

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

Comments

Amit Verma · Accepted Answer · 2021-06-08 12:33:57Z

0

your OR condition is wrong.

SELECT * 
FROM target_table 
where (0% = '${wickets}' OR 10% = '${wickets}'  OR 20% = '${wickets}') AND Overs = '${overs}'`

answered Jun 8, 2021 at 12:33

Amit Verma

2,4882 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

dynamic mysql query specific value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related