mysql> create table `test` (`val` longtext);
Query OK, 0 rows affected (0.45 sec)
mysql> insert into `test` SET `val` = '000123';
Query OK, 1 row affected (0.02 sec)
mysql> select * from `test` where `val` = 123;
+--------+
| val |
+--------+
| 000123 |
+--------+
1 row in set (0.00 sec)('1' == 1) -> (atoi('1') == 1) или('1' == 1) -> ('1' == (char *)1)
SELECT `street`
FROM (
SELECT * FROM
@street:= TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(`adress`, ',', -2), ',', 1)),
CONCAT_WS(' ', SUBSTRING(@street, LOCATE(' ', @street)), SUBSTRING_INDEX(@street, ' ', 1)) AS `street`
FROM `test`
) AS `t`SELECT
@street:= TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(`adress`, ',', -2), ',', 1)),
CONCAT_WS(' ', SUBSTRING(@street, LOCATE(' ', @street)), SUBSTRING_INDEX(@street, ' ', 1))
FROM `test`
</sql>{
"array": [
{"key1": "val1"},
{"key2": {
"xkey": ["xval1", "xval2", "xval3"],
"zkey": "zval"}
},
"val3"
]
}
'0001566' = 1566 => истина
'0001566' = '1566' => ложь