show tables like is weird

[bonosa]

I have a table called pru_1_a, and one called pru_10_b. If I say

show tables like "pru_1_%" I get both listed. This is odd. What am I doing wrong?
Thanks,
sb

 

[cLFlaVA]

the underscore means, match any one character for each underscore i provide.

so, the following tables would match "pru_1_%":

[tt]
prub13djskdsjdks
pru312
pru-1one
[/tt]

http://dev.mysql.com/doc/maxdb/en/8c/ccce27c71c11d2a97100a0c9449261/content.htm

*cLFlaVA
----------------------------
[tt]a frickin' twelve-gauge, what do you think?[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[bonosa]

I am in trouble!! My tables are labelled as pru_1_abc, pru_2_abc etc and I have based my searches on looking for the all tables that have "_1_" in them or "_2_". So does this mean that I should change the naming system? I looked justnow at

http://dev.mysql.com/doc/mysql/en/legal-names.html

and I see that '_" is illegal. So i am off to change my naming system...

Thanks,
sb

 

[bonosa]

Oh no. I thought it was "_" not allowed so I tried "-" but its not ok with that. So if I stay with my "_" how do I search for files like "_a_" where the underscore doesnt mean anything else but underscore If its not good what can I use? I need to sandwich that central character - what can I use?
thanks in advance,
sb

 

[TonyGroves]

To make a _ be treated as an ordinary character, escape it with a backslash:[tt]
LIKE "pru\_1\_%

 

[bonosa]

Many thanks. I didnt quite grasp that from the documentation.
Appreciate the help,
sb