Answers for "mysql select non integer values"

SQL
3

mysql select column where has non int values

/*find rows with non int value*/
select * from my_table where abs(user_id) =0;
Posted by: Guest on April-12-2022
0

mysql select non integer values

select * from mytable where mycolumn NOT REGEXP '^-?[0-9]+$';
Posted by: Guest on April-12-2022

Code answers related to "mysql select non integer values"

Code answers related to "SQL"

Browse Popular Code Answers by Language