regex - mysql regexp varchar value which contains \0 -


i'm testing regexp feature, , met problem. sql statement likes:

select field table field regexp '^[a-z][a-z0-9\\.]*[a-z0-9]$' limit 1; 

it matches row, field contains more a-z0-9. characters. in hex, value is:

61 726d 0000 00ab 003f 3f00 

i want let such rows filtered out. what's correct sql statement can write?


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -