I want to list all database which has the common starting word and after it should have uppercase letters. (using MYSQL)
eg: test_vino_JY test_vino_JI test_vino_ij test_vino_klm
In the above example i want to list only test_vino_JY, test_vino_JI
May i know how to do that. I tried using the below query, its not working. Please help me on this.
SHOW DATABASES WHERE `Database` REGEXP '^test_vino_+[A-Z]';