likeの一文字ワイルドカード
勘違いしていたのでめも。
mysqlでの一文字一致は「?」ではなく、「_」でした。
mysql> select * from rr where name like 'db2%'; +----+------+-------+------+---------------+-----+-------+ | id | zone | name | type | data | aux | ttl | +----+------+-------+------+---------------+-----+-------+ | 4 | 1 | db2m | A | 192.168.2.163 | 100 | 86400 | | 5 | 1 | db2s | A | 192.168.2.163 | 20 | 86400 | | 6 | 1 | db2s | A | 192.168.2.164 | 50 | 86400 | | 71 | 1 | db2s1 | A | 192.168.2.164 | 100 | 86400 | +----+------+-------+------+---------------+-----+-------+ 4 rows in set (0.00 sec)
mysql> select * from rr where name like 'db2?'; Empty set (0.00 sec)
mysql> select * from rr where name like 'db2_'; +----+------+------+------+---------------+-----+-------+ | id | zone | name | type | data | aux | ttl | +----+------+------+------+---------------+-----+-------+ | 4 | 1 | db2m | A | 192.168.2.163 | 100 | 86400 | | 5 | 1 | db2s | A | 192.168.2.163 | 20 | 86400 | | 6 | 1 | db2s | A | 192.168.2.164 | 50 | 86400 | +----+------+------+------+---------------+-----+-------+ 3 rows in set (0.00 sec)