Having trouble with placeholder LIKE statement in psycopg

June 7, 2024

It only seems to be these two lines, as I have other queries with LIKE statements that work no issue. I have other commands with a “%s” placeholder in the middle, and a LIKE statement, and those work no issue. And as mentioned, they worked no problem when I was using sqlite, but since switching they don’t.

https://www.reddit.com/r/PostgreSQL/comments/15jb37k/having_trouble_with_placeholder_like_statement_in/

Having trouble with placeholder LIKE statement in psycopg <body> <h1> Array ( [0] => gaving trouble with placeholder like statement in psycopg [1] => baving trouble with placeholder like statement in psycopg [2] => naving trouble with placeholder like statement in psycopg [3] => javing trouble with placeholder like statement in psycopg [4] => uaving trouble with placeholder like statement in psycopg [5] => yaving trouble with placeholder like statement in psycopg [6] => hzving trouble with placeholder like statement in psycopg [7] => hsving trouble with placeholder like statement in psycopg [8] => hwving trouble with placeholder like statement in psycopg [9] => hqving trouble with placeholder like statement in psycopg [10] => hacing trouble with placeholder like statement in psycopg [11] => habing trouble with placeholder like statement in psycopg [12] => haging trouble with placeholder like statement in psycopg [13] => hafing trouble with placeholder like statement in psycopg [14] => havung trouble with placeholder like statement in psycopg [15] => havjng trouble with placeholder like statement in psycopg [16] => havkng trouble with placeholder like statement in psycopg [17] => havong trouble with placeholder like statement in psycopg [18] => hav9ng trouble with placeholder like statement in psycopg [19] => hav8ng trouble with placeholder like statement in psycopg [20] => havibg trouble with placeholder like statement in psycopg [21] => havimg trouble with placeholder like statement in psycopg [22] => havijg trouble with placeholder like statement in psycopg [23] => havihg trouble with placeholder like statement in psycopg [24] => havinf trouble with placeholder like statement in psycopg [25] => havinv trouble with placeholder like statement in psycopg [26] => havinb trouble with placeholder like statement in psycopg [27] => havinh trouble with placeholder like statement in psycopg [28] => haviny trouble with placeholder like statement in psycopg [29] => havint trouble with placeholder like statement in psycopg [30] => having rrouble with placeholder like statement in psycopg [31] => having frouble with placeholder like statement in psycopg [32] => having grouble with placeholder like statement in psycopg [33] => having yrouble with placeholder like statement in psycopg [34] => having 6rouble with placeholder like statement in psycopg [35] => having 5rouble with placeholder like statement in psycopg [36] => having teouble with placeholder like statement in psycopg [37] => having tdouble with placeholder like statement in psycopg [38] => having tfouble with placeholder like statement in psycopg [39] => having ttouble with placeholder like statement in psycopg [40] => having t5ouble with placeholder like statement in psycopg [41] => having t4ouble with placeholder like statement in psycopg [42] => having triuble with placeholder like statement in psycopg [43] => having trkuble with placeholder like statement in psycopg [44] => having trluble with placeholder like statement in psycopg [45] => having trpuble with placeholder like statement in psycopg [46] => having tr0uble with placeholder like statement in psycopg [47] => having tr9uble with placeholder like statement in psycopg [48] => having troyble with placeholder like statement in psycopg [49] => having trohble with placeholder like statement in psycopg [50] => having trojble with placeholder like statement in psycopg [51] => having troible with placeholder like statement in psycopg [52] => having tro8ble with placeholder like statement in psycopg [53] => having tro7ble with placeholder like statement in psycopg [54] => having trouvle with placeholder like statement in psycopg [55] => having trounle with placeholder like statement in psycopg [56] => having trouhle with placeholder like statement in psycopg [57] => having trougle with placeholder like statement in psycopg [58] => having troubke with placeholder like statement in psycopg [59] => having troubpe with placeholder like statement in psycopg [60] => having trouboe with placeholder like statement in psycopg [61] => having troublw with placeholder like statement in psycopg [62] => having troubls with placeholder like statement in psycopg [63] => having troubld with placeholder like statement in psycopg [64] => having troublr with placeholder like statement in psycopg [65] => having troubl4 with placeholder like statement in psycopg [66] => having troubl3 with placeholder like statement in psycopg [67] => having trouble qith placeholder like statement in psycopg [68] => having trouble aith placeholder like statement in psycopg [69] => having trouble sith placeholder like statement in psycopg [70] => having trouble eith placeholder like statement in psycopg [71] => having trouble 3ith placeholder like statement in psycopg [72] => having trouble 2ith placeholder like statement in psycopg [73] => having trouble wuth placeholder like statement in psycopg [74] => having trouble wjth placeholder like statement in psycopg [75] => having trouble wkth placeholder like statement in psycopg [76] => having trouble woth placeholder like statement in psycopg [77] => having trouble w9th placeholder like statement in psycopg [78] => having trouble w8th placeholder like statement in psycopg [79] => having trouble wirh placeholder like statement in psycopg [80] => having trouble wifh placeholder like statement in psycopg [81] => having trouble wigh placeholder like statement in psycopg [82] => having trouble wiyh placeholder like statement in psycopg [83] => having trouble wi6h placeholder like statement in psycopg [84] => having trouble wi5h placeholder like statement in psycopg [85] => having trouble witg placeholder like statement in psycopg [86] => having trouble witb placeholder like statement in psycopg [87] => having trouble witn placeholder like statement in psycopg [88] => having trouble witj placeholder like statement in psycopg [89] => having trouble witu placeholder like statement in psycopg [90] => having trouble wity placeholder like statement in psycopg [91] => having trouble with olaceholder like statement in psycopg [92] => having trouble with llaceholder like statement in psycopg [93] => having trouble with -laceholder like statement in psycopg [94] => having trouble with 0laceholder like statement in psycopg [95] => having trouble with pkaceholder like statement in psycopg [96] => having trouble with ppaceholder like statement in psycopg [97] => having trouble with poaceholder like statement in psycopg [98] => having trouble with plzceholder like statement in psycopg [99] => having trouble with plsceholder like statement in psycopg [100] => having trouble with plwceholder like statement in psycopg [101] => having trouble with plqceholder like statement in psycopg [102] => having trouble with plaxeholder like statement in psycopg [103] => having trouble with plaveholder like statement in psycopg [104] => having trouble with plafeholder like statement in psycopg [105] => having trouble with pladeholder like statement in psycopg [106] => having trouble with placwholder like statement in psycopg [107] => having trouble with placsholder like statement in psycopg [108] => having trouble with placdholder like statement in psycopg [109] => having trouble with placrholder like statement in psycopg [110] => having trouble with plac4holder like statement in psycopg [111] => having trouble with plac3holder like statement in psycopg [112] => having trouble with placegolder like statement in psycopg [113] => having trouble with placebolder like statement in psycopg [114] => having trouble with placenolder like statement in psycopg [115] => having trouble with placejolder like statement in psycopg [116] => having trouble with placeuolder like statement in psycopg [117] => having trouble with placeyolder like statement in psycopg [118] => having trouble with placehilder like statement in psycopg [119] => having trouble with placehklder like statement in psycopg [120] => having trouble with placehllder like statement in psycopg [121] => having trouble with placehplder like statement in psycopg [122] => having trouble with placeh0lder like statement in psycopg [123] => having trouble with placeh9lder like statement in psycopg [124] => having trouble with placehokder like statement in psycopg [125] => having trouble with placehopder like statement in psycopg [126] => having trouble with placehooder like statement in psycopg [127] => having trouble with placeholser like statement in psycopg [128] => having trouble with placeholxer like statement in psycopg [129] => having trouble with placeholcer like statement in psycopg [130] => having trouble with placeholfer like statement in psycopg [131] => having trouble with placeholrer like statement in psycopg [132] => having trouble with placeholeer like statement in psycopg [133] => having trouble with placeholdwr like statement in psycopg [134] => having trouble with placeholdsr like statement in psycopg [135] => having trouble with placeholddr like statement in psycopg [136] => having trouble with placeholdrr like statement in psycopg [137] => having trouble with placehold4r like statement in psycopg [138] => having trouble with placehold3r like statement in psycopg [139] => having trouble with placeholdee like statement in psycopg [140] => having trouble with placeholded like statement in psycopg [141] => having trouble with placeholdef like statement in psycopg [142] => having trouble with placeholdet like statement in psycopg [143] => having trouble with placeholde5 like statement in psycopg [144] => having trouble with placeholde4 like statement in psycopg [145] => having trouble with placeholder kike statement in psycopg [146] => having trouble with placeholder pike statement in psycopg [147] => having trouble with placeholder oike statement in psycopg [148] => having trouble with placeholder luke statement in psycopg [149] => having trouble with placeholder ljke statement in psycopg [150] => having trouble with placeholder lkke statement in psycopg [151] => having trouble with placeholder loke statement in psycopg [152] => having trouble with placeholder l9ke statement in psycopg [153] => having trouble with placeholder l8ke statement in psycopg [154] => having trouble with placeholder lije statement in psycopg [155] => having trouble with placeholder lime statement in psycopg [156] => having trouble with placeholder lile statement in psycopg [157] => having trouble with placeholder lioe statement in psycopg [158] => having trouble with placeholder liie statement in psycopg [159] => having trouble with placeholder likw statement in psycopg [160] => having trouble with placeholder liks statement in psycopg [161] => having trouble with placeholder likd statement in psycopg [162] => having trouble with placeholder likr statement in psycopg [163] => having trouble with placeholder lik4 statement in psycopg [164] => having trouble with placeholder lik3 statement in psycopg [165] => having trouble with placeholder like atatement in psycopg [166] => having trouble with placeholder like ztatement in psycopg [167] => having trouble with placeholder like xtatement in psycopg [168] => having trouble with placeholder like dtatement in psycopg [169] => having trouble with placeholder like etatement in psycopg [170] => having trouble with placeholder like wtatement in psycopg [171] => having trouble with placeholder like sratement in psycopg [172] => having trouble with placeholder like sfatement in psycopg [173] => having trouble with placeholder like sgatement in psycopg [174] => having trouble with placeholder like syatement in psycopg [175] => having trouble with placeholder like s6atement in psycopg [176] => having trouble with placeholder like s5atement in psycopg [177] => having trouble with placeholder like stztement in psycopg [178] => having trouble with placeholder like ststement in psycopg [179] => having trouble with placeholder like stwtement in psycopg [180] => having trouble with placeholder like stqtement in psycopg [181] => having trouble with placeholder like starement in psycopg [182] => having trouble with placeholder like stafement in psycopg [183] => having trouble with placeholder like stagement in psycopg [184] => having trouble with placeholder like stayement in psycopg [185] => having trouble with placeholder like sta6ement in psycopg [186] => having trouble with placeholder like sta5ement in psycopg [187] => having trouble with placeholder like statwment in psycopg [188] => having trouble with placeholder like statsment in psycopg [189] => having trouble with placeholder like statdment in psycopg [190] => having trouble with placeholder like statrment in psycopg [191] => having trouble with placeholder like stat4ment in psycopg [192] => having trouble with placeholder like stat3ment in psycopg [193] => having trouble with placeholder like statenent in psycopg [194] => having trouble with placeholder like statekent in psycopg [195] => having trouble with placeholder like statejent in psycopg [196] => having trouble with placeholder like statemwnt in psycopg [197] => having trouble with placeholder like statemsnt in psycopg [198] => having trouble with placeholder like statemdnt in psycopg [199] => having trouble with placeholder like statemrnt in psycopg [200] => having trouble with placeholder like statem4nt in psycopg [201] => having trouble with placeholder like statem3nt in psycopg [202] => having trouble with placeholder like statemebt in psycopg [203] => having trouble with placeholder like statememt in psycopg [204] => having trouble with placeholder like statemejt in psycopg [205] => having trouble with placeholder like statemeht in psycopg [206] => having trouble with placeholder like statemenr in psycopg [207] => having trouble with placeholder like statemenf in psycopg [208] => having trouble with placeholder like statemeng in psycopg [209] => having trouble with placeholder like statemeny in psycopg [210] => having trouble with placeholder like statemen6 in psycopg [211] => having trouble with placeholder like statemen5 in psycopg [212] => having trouble with placeholder like statement un psycopg [213] => having trouble with placeholder like statement jn psycopg [214] => having trouble with placeholder like statement kn psycopg [215] => having trouble with placeholder like statement on psycopg [216] => having trouble with placeholder like statement 9n psycopg [217] => having trouble with placeholder like statement 8n psycopg [218] => having trouble with placeholder like statement ib psycopg [219] => having trouble with placeholder like statement im psycopg [220] => having trouble with placeholder like statement ij psycopg [221] => having trouble with placeholder like statement ih psycopg [222] => having trouble with placeholder like statement in osycopg [223] => having trouble with placeholder like statement in lsycopg [224] => having trouble with placeholder like statement in -sycopg [225] => having trouble with placeholder like statement in 0sycopg [226] => having trouble with placeholder like statement in paycopg [227] => having trouble with placeholder like statement in pzycopg [228] => having trouble with placeholder like statement in pxycopg [229] => having trouble with placeholder like statement in pdycopg [230] => having trouble with placeholder like statement in peycopg [231] => having trouble with placeholder like statement in pwycopg [232] => having trouble with placeholder like statement in pstcopg [233] => having trouble with placeholder like statement in psgcopg [234] => having trouble with placeholder like statement in pshcopg [235] => having trouble with placeholder like statement in psucopg [236] => having trouble with placeholder like statement in ps7copg [237] => having trouble with placeholder like statement in ps6copg [238] => having trouble with placeholder like statement in psyxopg [239] => having trouble with placeholder like statement in psyvopg [240] => having trouble with placeholder like statement in psyfopg [241] => having trouble with placeholder like statement in psydopg [242] => having trouble with placeholder like statement in psycipg [243] => having trouble with placeholder like statement in psyckpg [244] => having trouble with placeholder like statement in psyclpg [245] => having trouble with placeholder like statement in psycppg [246] => having trouble with placeholder like statement in psyc0pg [247] => having trouble with placeholder like statement in psyc9pg [248] => having trouble with placeholder like statement in psycoog [249] => having trouble with placeholder like statement in psycolg [250] => having trouble with placeholder like statement in psyco-g [251] => having trouble with placeholder like statement in psyco0g [252] => having trouble with placeholder like statement in psycopf [253] => having trouble with placeholder like statement in psycopv [254] => having trouble with placeholder like statement in psycopb [255] => having trouble with placeholder like statement in psycoph [256] => having trouble with placeholder like statement in psycopy [257] => having trouble with placeholder like statement in psycopt ) </h1> </body>