Search different SQL column with similar where clause
Replace a column in the where clause and convert all numbers from text to numeric, by replacing the leading 0 with the code 359.
Start file
SELECT * FROM numbers WHERE local_number IN (
"058307327",
"058307328",
"058307329"
)
End file
SELECT * FROM numbers WHERE int_number IN (
35958307327,
35958307328,
35958307329
)
View Diff
1,4c1,4
< SELECT * FROM numbers WHERE local_number IN (
< "058307327",
< "058307328",
< "058307329"
---
> SELECT * FROM numbers WHERE int_number IN (
> 35958307327,
> 35958307328,
> 35958307329
Solutions by @valacar:
Unlock 2 remaining solutions by signing in and submitting your own entry