samedi 25 avril 2015

Select ___where __LIKE ___


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