Mysql help [find/replace]

[Kymmy]

Is there any way in the regular expresion for doing a "any character" find

In other words if I want to search for any word beginning with A and ending in Z but with any two characters inbetween for example A12Z or AcdZ or A:3Z is there any way of doing it..

Just thought I;d ask as I do have a way of doing it to an SQL dump but wanted to know if I could do it directly via either command line or phpmyadmin

[Wicked_and_Crazy]

select * from tablename where columnname like 'A%%Z'

[Kymmy]

Cool will give it a try

Thank you

You dont need 2 %'s

Also note that that A%Z will match AxxZ or AZ or AxxxxxxxxxZ

If you want it to be just two chars use _ i.e. A__Z

[Wicked_and_Crazy]

Originally Posted by Paul M

You dont need 2 %'s

Also note that that A%Z will match AxxZ or AZ or AxxxxxxxxxZ

If you want it to be just two chars use _ i.e. A__Z

Whoops, didnt mean to put two % in (although it would still work). Must admit i had assumed that the column was 4 chars in width

[Kymmy]

Paul, thank you very much, exactly what I was after..