SQL – Using placeholders to retrieve rows that are LIKE the placeholder

May 2, 2025

The query returns the restaurant that serves both of these items; I am trying to create a query that checks if inputted drink is LIKE text in both drinkvariety & drinkname columns in Drinks table, and that checks if inputted food is LIKE text in both foodcategory and foodname in Food table. Only when the query inputted placeholders are LIKE …

https://stackoverflow.com/questions/54984673/sql-using-placeholders-to-retrieve-rows-that-are-like-the-placeholder

SQL – Using placeholders to retrieve rows that are LIKE the placeholder <body> <h1> Array ( [0] => aql – using placeholders to retrieve rows that are like the placeholder [1] => zql – using placeholders to retrieve rows that are like the placeholder [2] => xql – using placeholders to retrieve rows that are like the placeholder [3] => dql – using placeholders to retrieve rows that are like the placeholder [4] => eql – using placeholders to retrieve rows that are like the placeholder [5] => wql – using placeholders to retrieve rows that are like the placeholder [6] => s1l – using placeholders to retrieve rows that are like the placeholder [7] => s2l – using placeholders to retrieve rows that are like the placeholder [8] => swl – using placeholders to retrieve rows that are like the placeholder [9] => sal – using placeholders to retrieve rows that are like the placeholder [10] => sqk – using placeholders to retrieve rows that are like the placeholder [11] => sqp – using placeholders to retrieve rows that are like the placeholder [12] => sqo – using placeholders to retrieve rows that are like the placeholder [13] => sql ᰫ using placeholders to retrieve rows that are like the placeholder [14] => sql &#u211; using placeholders to retrieve rows that are like the placeholder [15] => sql &#i211; using placeholders to retrieve rows that are like the placeholder [16] => sql ⏻ using placeholders to retrieve rows that are like the placeholder [17] => sql ᾯ using placeholders to retrieve rows that are like the placeholder [18] => sql &#8q11; using placeholders to retrieve rows that are like the placeholder [19] => sql &#8w11; using placeholders to retrieve rows that are like the placeholder [20] => sql ⁷ using placeholders to retrieve rows that are like the placeholder [21] => sql ” using placeholders to retrieve rows that are like the placeholder [22] => sql &#82q1; using placeholders to retrieve rows that are like the placeholder [23] => sql — using placeholders to retrieve rows that are like the placeholder [24] => sql &#821q; using placeholders to retrieve rows that are like the placeholder [25] => sql – ysing placeholders to retrieve rows that are like the placeholder [26] => sql – hsing placeholders to retrieve rows that are like the placeholder [27] => sql – jsing placeholders to retrieve rows that are like the placeholder [28] => sql – ising placeholders to retrieve rows that are like the placeholder [29] => sql – 8sing placeholders to retrieve rows that are like the placeholder [30] => sql – 7sing placeholders to retrieve rows that are like the placeholder [31] => sql – uaing placeholders to retrieve rows that are like the placeholder [32] => sql – uzing placeholders to retrieve rows that are like the placeholder [33] => sql – uxing placeholders to retrieve rows that are like the placeholder [34] => sql – uding placeholders to retrieve rows that are like the placeholder [35] => sql – ueing placeholders to retrieve rows that are like the placeholder [36] => sql – uwing placeholders to retrieve rows that are like the placeholder [37] => sql – usung placeholders to retrieve rows that are like the placeholder [38] => sql – usjng placeholders to retrieve rows that are like the placeholder [39] => sql – uskng placeholders to retrieve rows that are like the placeholder [40] => sql – usong placeholders to retrieve rows that are like the placeholder [41] => sql – us9ng placeholders to retrieve rows that are like the placeholder [42] => sql – us8ng placeholders to retrieve rows that are like the placeholder [43] => sql – usibg placeholders to retrieve rows that are like the placeholder [44] => sql – usimg placeholders to retrieve rows that are like the placeholder [45] => sql – usijg placeholders to retrieve rows that are like the placeholder [46] => sql – usihg placeholders to retrieve rows that are like the placeholder [47] => sql – usinf placeholders to retrieve rows that are like the placeholder [48] => sql – usinv placeholders to retrieve rows that are like the placeholder [49] => sql – usinb placeholders to retrieve rows that are like the placeholder [50] => sql – usinh placeholders to retrieve rows that are like the placeholder [51] => sql – usiny placeholders to retrieve rows that are like the placeholder [52] => sql – usint placeholders to retrieve rows that are like the placeholder [53] => sql – using olaceholders to retrieve rows that are like the placeholder [54] => sql – using llaceholders to retrieve rows that are like the placeholder [55] => sql – using -laceholders to retrieve rows that are like the placeholder [56] => sql – using 0laceholders to retrieve rows that are like the placeholder [57] => sql – using pkaceholders to retrieve rows that are like the placeholder [58] => sql – using ppaceholders to retrieve rows that are like the placeholder [59] => sql – using poaceholders to retrieve rows that are like the placeholder [60] => sql – using plzceholders to retrieve rows that are like the placeholder [61] => sql – using plsceholders to retrieve rows that are like the placeholder [62] => sql – using plwceholders to retrieve rows that are like the placeholder [63] => sql – using plqceholders to retrieve rows that are like the placeholder [64] => sql – using plaxeholders to retrieve rows that are like the placeholder [65] => sql – using plaveholders to retrieve rows that are like the placeholder [66] => sql – using plafeholders to retrieve rows that are like the placeholder [67] => sql – using pladeholders to retrieve rows that are like the placeholder [68] => sql – using placwholders to retrieve rows that are like the placeholder [69] => sql – using placsholders to retrieve rows that are like the placeholder [70] => sql – using placdholders to retrieve rows that are like the placeholder [71] => sql – using placrholders to retrieve rows that are like the placeholder [72] => sql – using plac4holders to retrieve rows that are like the placeholder [73] => sql – using plac3holders to retrieve rows that are like the placeholder [74] => sql – using placegolders to retrieve rows that are like the placeholder [75] => sql – using placebolders to retrieve rows that are like the placeholder [76] => sql – using placenolders to retrieve rows that are like the placeholder [77] => sql – using placejolders to retrieve rows that are like the placeholder [78] => sql – using placeuolders to retrieve rows that are like the placeholder [79] => sql – using placeyolders to retrieve rows that are like the placeholder [80] => sql – using placehilders to retrieve rows that are like the placeholder [81] => sql – using placehklders to retrieve rows that are like the placeholder [82] => sql – using placehllders to retrieve rows that are like the placeholder [83] => sql – using placehplders to retrieve rows that are like the placeholder [84] => sql – using placeh0lders to retrieve rows that are like the placeholder [85] => sql – using placeh9lders to retrieve rows that are like the placeholder [86] => sql – using placehokders to retrieve rows that are like the placeholder [87] => sql – using placehopders to retrieve rows that are like the placeholder [88] => sql – using placehooders to retrieve rows that are like the placeholder [89] => sql – using placeholsers to retrieve rows that are like the placeholder [90] => sql – using placeholxers to retrieve rows that are like the placeholder [91] => sql – using placeholcers to retrieve rows that are like the placeholder [92] => sql – using placeholfers to retrieve rows that are like the placeholder [93] => sql – using placeholrers to retrieve rows that are like the placeholder [94] => sql – using placeholeers to retrieve rows that are like the placeholder [95] => sql – using placeholdwrs to retrieve rows that are like the placeholder [96] => sql – using placeholdsrs to retrieve rows that are like the placeholder [97] => sql – using placeholddrs to retrieve rows that are like the placeholder [98] => sql – using placeholdrrs to retrieve rows that are like the placeholder [99] => sql – using placehold4rs to retrieve rows that are like the placeholder [100] => sql – using placehold3rs to retrieve rows that are like the placeholder [101] => sql – using placeholdees to retrieve rows that are like the placeholder [102] => sql – using placeholdeds to retrieve rows that are like the placeholder [103] => sql – using placeholdefs to retrieve rows that are like the placeholder [104] => sql – using placeholdets to retrieve rows that are like the placeholder [105] => sql – using placeholde5s to retrieve rows that are like the placeholder [106] => sql – using placeholde4s to retrieve rows that are like the placeholder [107] => sql – using placeholdera to retrieve rows that are like the placeholder [108] => sql – using placeholderz to retrieve rows that are like the placeholder [109] => sql – using placeholderx to retrieve rows that are like the placeholder [110] => sql – using placeholderd to retrieve rows that are like the placeholder [111] => sql – using placeholdere to retrieve rows that are like the placeholder [112] => sql – using placeholderw to retrieve rows that are like the placeholder [113] => sql – using placeholders ro retrieve rows that are like the placeholder [114] => sql – using placeholders fo retrieve rows that are like the placeholder [115] => sql – using placeholders go retrieve rows that are like the placeholder [116] => sql – using placeholders yo retrieve rows that are like the placeholder [117] => sql – using placeholders 6o retrieve rows that are like the placeholder [118] => sql – using placeholders 5o retrieve rows that are like the placeholder [119] => sql – using placeholders ti retrieve rows that are like the placeholder [120] => sql – using placeholders tk retrieve rows that are like the placeholder [121] => sql – using placeholders tl retrieve rows that are like the placeholder [122] => sql – using placeholders tp retrieve rows that are like the placeholder [123] => sql – using placeholders t0 retrieve rows that are like the placeholder [124] => sql – using placeholders t9 retrieve rows that are like the placeholder [125] => sql – using placeholders to eetrieve rows that are like the placeholder [126] => sql – using placeholders to detrieve rows that are like the placeholder [127] => sql – using placeholders to fetrieve rows that are like the placeholder [128] => sql – using placeholders to tetrieve rows that are like the placeholder [129] => sql – using placeholders to 5etrieve rows that are like the placeholder [130] => sql – using placeholders to 4etrieve rows that are like the placeholder [131] => sql – using placeholders to rwtrieve rows that are like the placeholder [132] => sql – using placeholders to rstrieve rows that are like the placeholder [133] => sql – using placeholders to rdtrieve rows that are like the placeholder [134] => sql – using placeholders to rrtrieve rows that are like the placeholder [135] => sql – using placeholders to r4trieve rows that are like the placeholder [136] => sql – using placeholders to r3trieve rows that are like the placeholder [137] => sql – using placeholders to rerrieve rows that are like the placeholder [138] => sql – using placeholders to refrieve rows that are like the placeholder [139] => sql – using placeholders to regrieve rows that are like the placeholder [140] => sql – using placeholders to reyrieve rows that are like the placeholder [141] => sql – using placeholders to re6rieve rows that are like the placeholder [142] => sql – using placeholders to re5rieve rows that are like the placeholder [143] => sql – using placeholders to reteieve rows that are like the placeholder [144] => sql – using placeholders to retdieve rows that are like the placeholder [145] => sql – using placeholders to retfieve rows that are like the placeholder [146] => sql – using placeholders to rettieve rows that are like the placeholder [147] => sql – using placeholders to ret5ieve rows that are like the placeholder [148] => sql – using placeholders to ret4ieve rows that are like the placeholder [149] => sql – using placeholders to retrueve rows that are like the placeholder [150] => sql – using placeholders to retrjeve rows that are like the placeholder [151] => sql – using placeholders to retrkeve rows that are like the placeholder [152] => sql – using placeholders to retroeve rows that are like the placeholder [153] => sql – using placeholders to retr9eve rows that are like the placeholder [154] => sql – using placeholders to retr8eve rows that are like the placeholder [155] => sql – using placeholders to retriwve rows that are like the placeholder [156] => sql – using placeholders to retrisve rows that are like the placeholder [157] => sql – using placeholders to retridve rows that are like the placeholder [158] => sql – using placeholders to retrirve rows that are like the placeholder [159] => sql – using placeholders to retri4ve rows that are like the placeholder [160] => sql – using placeholders to retri3ve rows that are like the placeholder [161] => sql – using placeholders to retriece rows that are like the placeholder [162] => sql – using placeholders to retriebe rows that are like the placeholder [163] => sql – using placeholders to retriege rows that are like the placeholder [164] => sql – using placeholders to retriefe rows that are like the placeholder [165] => sql – using placeholders to retrievw rows that are like the placeholder [166] => sql – using placeholders to retrievs rows that are like the placeholder [167] => sql – using placeholders to retrievd rows that are like the placeholder [168] => sql – using placeholders to retrievr rows that are like the placeholder [169] => sql – using placeholders to retriev4 rows that are like the placeholder [170] => sql – using placeholders to retriev3 rows that are like the placeholder [171] => sql – using placeholders to retrieve eows that are like the placeholder [172] => sql – using placeholders to retrieve dows that are like the placeholder [173] => sql – using placeholders to retrieve fows that are like the placeholder [174] => sql – using placeholders to retrieve tows that are like the placeholder [175] => sql – using placeholders to retrieve 5ows that are like the placeholder [176] => sql – using placeholders to retrieve 4ows that are like the placeholder [177] => sql – using placeholders to retrieve riws that are like the placeholder [178] => sql – using placeholders to retrieve rkws that are like the placeholder [179] => sql – using placeholders to retrieve rlws that are like the placeholder [180] => sql – using placeholders to retrieve rpws that are like the placeholder [181] => sql – using placeholders to retrieve r0ws that are like the placeholder [182] => sql – using placeholders to retrieve r9ws that are like the placeholder [183] => sql – using placeholders to retrieve roqs that are like the placeholder [184] => sql – using placeholders to retrieve roas that are like the placeholder [185] => sql – using placeholders to retrieve ross that are like the placeholder [186] => sql – using placeholders to retrieve roes that are like the placeholder [187] => sql – using placeholders to retrieve ro3s that are like the placeholder [188] => sql – using placeholders to retrieve ro2s that are like the placeholder [189] => sql – using placeholders to retrieve rowa that are like the placeholder [190] => sql – using placeholders to retrieve rowz that are like the placeholder [191] => sql – using placeholders to retrieve rowx that are like the placeholder [192] => sql – using placeholders to retrieve rowd that are like the placeholder [193] => sql – using placeholders to retrieve rowe that are like the placeholder [194] => sql – using placeholders to retrieve roww that are like the placeholder [195] => sql – using placeholders to retrieve rows rhat are like the placeholder [196] => sql – using placeholders to retrieve rows fhat are like the placeholder [197] => sql – using placeholders to retrieve rows ghat are like the placeholder [198] => sql – using placeholders to retrieve rows yhat are like the placeholder [199] => sql – using placeholders to retrieve rows 6hat are like the placeholder [200] => sql – using placeholders to retrieve rows 5hat are like the placeholder [201] => sql – using placeholders to retrieve rows tgat are like the placeholder [202] => sql – using placeholders to retrieve rows tbat are like the placeholder [203] => sql – using placeholders to retrieve rows tnat are like the placeholder [204] => sql – using placeholders to retrieve rows tjat are like the placeholder [205] => sql – using placeholders to retrieve rows tuat are like the placeholder [206] => sql – using placeholders to retrieve rows tyat are like the placeholder [207] => sql – using placeholders to retrieve rows thzt are like the placeholder [208] => sql – using placeholders to retrieve rows thst are like the placeholder [209] => sql – using placeholders to retrieve rows thwt are like the placeholder [210] => sql – using placeholders to retrieve rows thqt are like the placeholder [211] => sql – using placeholders to retrieve rows thar are like the placeholder [212] => sql – using placeholders to retrieve rows thaf are like the placeholder [213] => sql – using placeholders to retrieve rows thag are like the placeholder [214] => sql – using placeholders to retrieve rows thay are like the placeholder [215] => sql – using placeholders to retrieve rows tha6 are like the placeholder [216] => sql – using placeholders to retrieve rows tha5 are like the placeholder [217] => sql – using placeholders to retrieve rows that zre like the placeholder [218] => sql – using placeholders to retrieve rows that sre like the placeholder [219] => sql – using placeholders to retrieve rows that wre like the placeholder [220] => sql – using placeholders to retrieve rows that qre like the placeholder [221] => sql – using placeholders to retrieve rows that aee like the placeholder [222] => sql – using placeholders to retrieve rows that ade like the placeholder [223] => sql – using placeholders to retrieve rows that afe like the placeholder [224] => sql – using placeholders to retrieve rows that ate like the placeholder [225] => sql – using placeholders to retrieve rows that a5e like the placeholder [226] => sql – using placeholders to retrieve rows that a4e like the placeholder [227] => sql – using placeholders to retrieve rows that arw like the placeholder [228] => sql – using placeholders to retrieve rows that ars like the placeholder [229] => sql – using placeholders to retrieve rows that ard like the placeholder [230] => sql – using placeholders to retrieve rows that arr like the placeholder [231] => sql – using placeholders to retrieve rows that ar4 like the placeholder [232] => sql – using placeholders to retrieve rows that ar3 like the placeholder [233] => sql – using placeholders to retrieve rows that are kike the placeholder [234] => sql – using placeholders to retrieve rows that are pike the placeholder [235] => sql – using placeholders to retrieve rows that are oike the placeholder [236] => sql – using placeholders to retrieve rows that are luke the placeholder [237] => sql – using placeholders to retrieve rows that are ljke the placeholder [238] => sql – using placeholders to retrieve rows that are lkke the placeholder [239] => sql – using placeholders to retrieve rows that are loke the placeholder [240] => sql – using placeholders to retrieve rows that are l9ke the placeholder [241] => sql – using placeholders to retrieve rows that are l8ke the placeholder [242] => sql – using placeholders to retrieve rows that are lije the placeholder [243] => sql – using placeholders to retrieve rows that are lime the placeholder [244] => sql – using placeholders to retrieve rows that are lile the placeholder [245] => sql – using placeholders to retrieve rows that are lioe the placeholder [246] => sql – using placeholders to retrieve rows that are liie the placeholder [247] => sql – using placeholders to retrieve rows that are likw the placeholder [248] => sql – using placeholders to retrieve rows that are liks the placeholder [249] => sql – using placeholders to retrieve rows that are likd the placeholder [250] => sql – using placeholders to retrieve rows that are likr the placeholder [251] => sql – using placeholders to retrieve rows that are lik4 the placeholder [252] => sql – using placeholders to retrieve rows that are lik3 the placeholder [253] => sql – using placeholders to retrieve rows that are like rhe placeholder [254] => sql – using placeholders to retrieve rows that are like fhe placeholder [255] => sql – using placeholders to retrieve rows that are like ghe placeholder [256] => sql – using placeholders to retrieve rows that are like yhe placeholder [257] => sql – using placeholders to retrieve rows that are like 6he placeholder [258] => sql – using placeholders to retrieve rows that are like 5he placeholder [259] => sql – using placeholders to retrieve rows that are like tge placeholder [260] => sql – using placeholders to retrieve rows that are like tbe placeholder [261] => sql – using placeholders to retrieve rows that are like tne placeholder [262] => sql – using placeholders to retrieve rows that are like tje placeholder [263] => sql – using placeholders to retrieve rows that are like tue placeholder [264] => sql – using placeholders to retrieve rows that are like tye placeholder [265] => sql – using placeholders to retrieve rows that are like thw placeholder [266] => sql – using placeholders to retrieve rows that are like ths placeholder [267] => sql – using placeholders to retrieve rows that are like thd placeholder [268] => sql – using placeholders to retrieve rows that are like thr placeholder [269] => sql – using placeholders to retrieve rows that are like th4 placeholder [270] => sql – using placeholders to retrieve rows that are like th3 placeholder [271] => sql – using placeholders to retrieve rows that are like the olaceholder [272] => sql – using placeholders to retrieve rows that are like the llaceholder [273] => sql – using placeholders to retrieve rows that are like the -laceholder [274] => sql – using placeholders to retrieve rows that are like the 0laceholder [275] => sql – using placeholders to retrieve rows that are like the pkaceholder [276] => sql – using placeholders to retrieve rows that are like the ppaceholder [277] => sql – using placeholders to retrieve rows that are like the poaceholder [278] => sql – using placeholders to retrieve rows that are like the plzceholder [279] => sql – using placeholders to retrieve rows that are like the plsceholder [280] => sql – using placeholders to retrieve rows that are like the plwceholder [281] => sql – using placeholders to retrieve rows that are like the plqceholder [282] => sql – using placeholders to retrieve rows that are like the plaxeholder [283] => sql – using placeholders to retrieve rows that are like the plaveholder [284] => sql – using placeholders to retrieve rows that are like the plafeholder [285] => sql – using placeholders to retrieve rows that are like the pladeholder [286] => sql – using placeholders to retrieve rows that are like the placwholder [287] => sql – using placeholders to retrieve rows that are like the placsholder [288] => sql – using placeholders to retrieve rows that are like the placdholder [289] => sql – using placeholders to retrieve rows that are like the placrholder [290] => sql – using placeholders to retrieve rows that are like the plac4holder [291] => sql – using placeholders to retrieve rows that are like the plac3holder [292] => sql – using placeholders to retrieve rows that are like the placegolder [293] => sql – using placeholders to retrieve rows that are like the placebolder [294] => sql – using placeholders to retrieve rows that are like the placenolder [295] => sql – using placeholders to retrieve rows that are like the placejolder [296] => sql – using placeholders to retrieve rows that are like the placeuolder [297] => sql – using placeholders to retrieve rows that are like the placeyolder [298] => sql – using placeholders to retrieve rows that are like the placehilder [299] => sql – using placeholders to retrieve rows that are like the placehklder [300] => sql – using placeholders to retrieve rows that are like the placehllder [301] => sql – using placeholders to retrieve rows that are like the placehplder [302] => sql – using placeholders to retrieve rows that are like the placeh0lder [303] => sql – using placeholders to retrieve rows that are like the placeh9lder [304] => sql – using placeholders to retrieve rows that are like the placehokder [305] => sql – using placeholders to retrieve rows that are like the placehopder [306] => sql – using placeholders to retrieve rows that are like the placehooder [307] => sql – using placeholders to retrieve rows that are like the placeholser [308] => sql – using placeholders to retrieve rows that are like the placeholxer [309] => sql – using placeholders to retrieve rows that are like the placeholcer [310] => sql – using placeholders to retrieve rows that are like the placeholfer [311] => sql – using placeholders to retrieve rows that are like the placeholrer [312] => sql – using placeholders to retrieve rows that are like the placeholeer [313] => sql – using placeholders to retrieve rows that are like the placeholdwr [314] => sql – using placeholders to retrieve rows that are like the placeholdsr [315] => sql – using placeholders to retrieve rows that are like the placeholddr [316] => sql – using placeholders to retrieve rows that are like the placeholdrr [317] => sql – using placeholders to retrieve rows that are like the placehold4r [318] => sql – using placeholders to retrieve rows that are like the placehold3r [319] => sql – using placeholders to retrieve rows that are like the placeholdee [320] => sql – using placeholders to retrieve rows that are like the placeholded [321] => sql – using placeholders to retrieve rows that are like the placeholdef [322] => sql – using placeholders to retrieve rows that are like the placeholdet [323] => sql – using placeholders to retrieve rows that are like the placeholde5 [324] => sql – using placeholders to retrieve rows that are like the placeholde4 ) </h1> </body>