I want to select all the tables which don'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 '%_%';
But it doesn't seem to work.
Aucun commentaire:
Enregistrer un commentaire