Pfthb

GUY — — — Von Guyana wurden zwei Athleten für die Weltmeisterschaften in London nominiert. Inhaltsverzeichnis 1 Ergebnisse 1.1 Männer 1.1.1 Laufdisziplinen 1.1.2 Sprung/Wurf 2 Weblinks Ergebnisse | Männer | Laufdisziplinen | Athlet Disziplin Vorlauf Halbfinale Finale Zeit Platz Zeit Platz Zeit Platz Winston George 200 m 20,61 s 28 20,74 s 22 ausgeschieden 400 m 46,02 s 35 ausgeschieden Sprung/Wurf | Athlet Disziplin Qualifikation Finale Weite/Höhe Platz Weite/Höhe Platz Troy Doris Dreisprung 16,42 m 22 ausgeschieden Weblinks | Liste aller Athleten mit Disziplin (englisch) .mw-parser-output div.NavFrameborder:1px solid #A2A9B1;clear:both;font-size:95%;margin-top:1.5em;min-height:0;padding:2px;text-align:center.mw-parser-output div.NavPicfloat:left;padding:2px.mw-parser-output div.NavHeadbackground-color:#EAECF0;font-weight:bold.mw-parser-output div.NavFrame:afterclear:both;content:"";display:block.mw-parser-output div.NavFrame+div.Nav...

0 I am running a simple query where comparing a TEXT column using NOT LIKE but the results are not coming correct. Tried a lot but no luck. Here is the query : SELECT * FROM `restaurant_session_log` WHERE `restId` = '176' OR branchId = '203' OR `multi_vendorId` LIKE '%,176%' OR `multi_vendorId` LIKE '%,176,%' OR `multi_vendorId` LIKE '%176,%' OR `multi_vendorId` LIKE '%[176]%' AND (`excluded_branch_id` NOT LIKE '%,203%' OR `excluded_branch_id` NOT LIKE '%,203,%' OR `excluded_branch_id` NOT LIKE '%203,%' OR `excluded_branch_id` NOT LIKE '%[203]%' ) And here is the result: Now the correct result would only include 2nd row, with id = 27707 because I have mentioned in the query to bring result where excluded_branch_id != %203% but I don't understand why it's giving the row with 203 in excluded_branch_id column. Please help! mysql sql share | improve this question asked N...