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 @stoyandimov:
Unlock 3 remaining solutions by signing in and submitting your own entry