lundi 25 juillet 2016

Select all fields value where all fileds value like some String

can someone help, i need to get all values from fields where all fields values like %someString%. My table have 17 fields, i don't want write all fields in query. DB Mysql.

select * from Deputes_APPEAL where filePath, checkForPlagiarism, contentOfResolution, countOfPages, dateForCheck, incomeNumber, incomingDate, mainWorker, nameAndAddressOfApplicant, nameOfDepute, outDate, outNumber, result, secondaryWorkers, shortContentOfAppeal, statusOfWorking, themeOfAppeal, TypeOfDeputeAppeal, unitWhoDoResolution like %someString%

Aucun commentaire:

Enregistrer un commentaire