samedi 25 avril 2015

Select ___where __LIKE ___


I want to select all the tables which doesn't contain the character '_' from a database, for this I used the request :

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema="DB_NAME" and TABLE_NAME NOT LIKE '%_%' ; 

And it doesnt seem to work . How can proceed ?


Aucun commentaire:

Enregistrer un commentaire