Sql

SELECT * FROM table WHERE YOUR_INTEGER_VALUE::varchar = 'string';
# or
SELECT * FROM table WHERE cast(YOUR_INTEGER_VALUE as varchar) = 'string';

SELECT * FROM table WHERE cast(YOUR_INTEGER_VALUE as varchar) = 'string of numbers'

PREVIOUS	NEXT

Code Example
Sql :: get date ISO in psql
Sql :: mysql query to check record exists in database table or not
Sql :: sql server update column based on another table
Sql :: mysql date time string format python
Sql :: sqlalchemy left join
Sql :: join update query in sql
Sql :: delete dublicate rows sql
Sql :: tsql insert
Sql :: sql get last id
Sql :: postgresql extract hour and minutes from timestamp
Sql :: show slave status mysql
Sql :: oracle sql listagg
Sql :: regex mongoose
Sql :: how to import large sql file in phpmyadmin in ubuntu
Sql :: mac install mysql
Sql :: count characters of string mysql
Sql :: command line mysql xampp
Sql :: oracle desc table primary key
Sql :: concat column data in sql laravel
Sql :: count column of tables psql
Sql :: datediff
Sql :: sql update table set text to lowercase
Sql :: download mysql 64 bit
Sql :: oracle list datafiles
Sql :: remove unique key from a table
Sql :: referential integrity constraint
Sql :: mysql record group by created date count
Sql :: add column postgres with default value
Sql :: how to combine diff colmun value using group by postgres
Sql :: null sql