Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

178
Views
searching for the winning id in bingo with SQL

I have created a bingo database (about 1000 id). User coupons are sent to the form on the website and they are sent to the database.

ID  
num1-1  num2-1  num3-1  num4-1  num5-1  num6-1  num7-1  num8-1  num9-1  
num1-2  num2-2  num3-2  num4-2  num5-2  num6-2  num7-2  num8-2  num9-2  
num1-3  num2-3  num3-3  num4-3  num5-3  num6-3  num7-3  num8-3  num9-3  

num"column"-"row"

the drawn numbers are transferred to a variable

How should I find that e.g. Id 261 has a match of 1 row or 2 rows or 3 rows (BINGO)

sample playing card

^sample playing card^

1
""  16  21  31  42  ""  60  ""  ""  
1   18  ""  33  ""  53  62  ""  ""  
2   ""  ""  38  ""  55  69  74  ""  

e.t.c ^in SQL^

and var draw = 2,5,8,...,3,38,...,55,69,...,74

and I want the message to be displayed, depending on the game mode, that id 1 has 1 row or 2 rows or 3 rows (BINGO)

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!