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