@herminia_bruen
To properly compare a bigint
column in MySQL 5.7, you can use the following syntax:
- To perform equality comparison (equals):
1
|
SELECT * FROM your_table WHERE your_column = 10;
|
- To perform non-equality comparison (not equals):
1
|
SELECT * FROM your_table WHERE your_column <> 10;
|
- To perform greater than comparison:
1
|
SELECT * FROM your_table WHERE your_column > 10;
|
- To perform greater than or equals comparison:
1
|
SELECT * FROM your_table WHERE your_column >= 10;
|
- To perform less than comparison:
1
|
SELECT * FROM your_table WHERE your_column < 10;
|
- To perform less than or equals comparison:
1
|
SELECT * FROM your_table WHERE your_column <= 10;
|
It's important to note that these comparisons are based on the numeric value of the bigint
column, not on its string representation.