A
A
Alex102142022-01-19 18:24:55
MySQL
Alex10214, 2022-01-19 18:24:55

How to get a column?

Greetings, I have remotely written a query code:
SELECT * FROM `DB` WHERE `id_key` = ''
All I can do is substitute the filter value by column into the `id_key` key. I can't change the request itself. Maybe there are ways to substitute something in empty quotes and get the entire column without filtering?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alfieros, 2022-01-19
@mrsexy

Can only be somehow

SELECT * FROM `DB` WHERE `id_key` > 0
SELECT ID FROM `DB` WHERE `id_key` > 0
SELECT ID FROM `DB` WHERE `id_key` < 1
SELECT * FROM `DB` WHERE `id_key` = ok
SELECT value FROM `DB` WHERE `id_key` = 1
SELECT value FROM `DB` WHERE `id_key` != ok
SELECT value FROM `DB` WHERE `id_key` = ok

To weed out unnecessary questions, try to check your requests here

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question