For example, this gets the row that stores "Sir Stripypants" in the column toy_name: select * from toys where toy_name = 'Sir Stripypants'; A condition can match many rows. He notes that you would need to create a temporary create a table with just those values (and a column for the count) and modify the code to select sts_id from the new table, and update the new table with the count: Thanks for your inputs. Who counts as a "player", for Steam achievement percentages? site design / logo © 2020 Stack Exchange Inc; user contributions licensed under cc by-sa. I need to set the enabled = False on the child combo box if there are no valid rows from the query. Help us help you - share some sample data and the result you're trying to get for it. Advantages and possible usages of encryption schemes with probabilistic decryption, How to show that Bell states are orthonormal, Looking for the title of a very old sci-fi short story where a human deters an alien invasion by answering questions truthfully, but cleverly, Reclassify raster values continuously instead of assigning them to specific groups, Make the "z80asm" assembler place an instruction at a known memory address.