Get like value in the row as column?
Mehtab
I have a table having data showing in picture 
When I run
SELECT * from pb_results where pb_results.winning_numbers LIKE '%130736%' OR pb_results.winning_numbers LIKE '%130737%' OR pb_results.winning_numbers LIKE '%130738%' and get result 
result can be multiple rows and how can i know which row is against which like value.... For example in above example i would like to get a column with value 130736... which shows me this is row is against this 130736.... how can i do this?
mcv
SELECT pb.*, "130736" as search_value from pb_results pb where pb_results.winning_numbers LIKE '%130736%'
UNION
SELECT pb.*, "130737" as search_value from pb_results pb where pb_results.winning_numbers LIKE '%130737%'
UNION
SELECT pb.*, "130738" as search_value from pb_results pb where pb_results.winning_numbers LIKE '%1307378%';
Will provide you results with an additional column of search_value which will have the search info that you request.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Is it possible to include the output of one snippet inside another?
- Next: stack trace with multiple caller methods
Related
Related Related
- 1
Get a value of a row in a column
- 2
Pandas - Get first row value of a given column
- 3
Get names of column with max value for each row
- 4
Get value from a certain row in a column
- 5
Get column header based on a value in each row
- 6
How to get the row with the maximum value of a summed column
- 7
Get column value with same row id
- 8
inner join to get row with max column value
- 9
Get value from dataframe based on column and row
- 10
Get value from a certain row in a column
- 11
Get column header based on a value in each row
- 12
get Database row column value with OleDbCommand
- 13
Get value in column from matrix of row numbers
- 14
get row and column depending on value using SQL?
- 15
Get the sum of like values in one column for each value in another column
- 16
How to get specific column value for a specific row value in AWK?
- 17
Get value of a column of a row where select option value changed
- 18
How to add row and column value as a tag of UIButton so that i can get row and column value on button click?
- 19
How to add row and column value as a tag of UIButton so that i can get row and column value on button click?
- 20
Redshift LIKE column value with %
- 21
Get cell value where column value equals row/column value in second sheet
- 22
how to get value from counter Column in cassandra with multiple row keys?
- 23
pandas how get row index by data frame column value
- 24
get column index for furthest row value to the right in a matrix
- 25
Using pandas to get max value per row and column header
- 26
Find the column with duplicate value across each row & get related values
- 27
In an SQL table, I get the last column's last row value
- 28
How to get last inserted row value from a column in string format?
- 29
get column name that matches specific row value in dataframe
Comments