[Solved]Help with search statement-SQLite & Python

Thread Rating:

Thread Modes

[Solved]Help with search statement-SQLite & Python

Extra
Spam, spam, eggs, and spam

Posts: 232

Threads: 81

Joined: Nov 2021

Reputation: 1

May-06-2022, 07:38 PM

Nevermind, I got it.

 #Display all records in the Items Table:
    cursor.execute("select * from items WHERE Name LIKE'%'||?||'%'",(userQuery,))

Messages In This Thread

RE: Help with search statement-SQLite & Python - by Extra - May-06-2022, 07:38 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	need help with data analysing with python and sqlite	Hardcool	2	445	Jan-30-2024, 06:49 AM Last Post: Athi
	python sqlite autoincrement in primary column	janeik	6	1,321	Aug-13-2023, 11:22 AM Last Post: janeik
	[Solved]Help with SQLite Login Form	Extra	7	2,101	Jun-25-2022, 10:53 AM Last Post: deanhystad
	Help with subtracting values using SQLite & Python	Extra	10	3,582	May-10-2022, 08:36 AM Last Post: ibreeden
	Help With Python SQLite Error	Extra	10	15,650	May-04-2022, 11:42 PM Last Post: Extra
	Python Sqlite	georgebijum	0	1,105	May-04-2022, 10:12 AM Last Post: georgebijum
	Importing data from a text file into an SQLite database with Python	macieju1974	7	4,289	Jun-29-2020, 08:51 PM Last Post: buran
	how to use items combobox in table name sqlite in python	hampython	1	2,760	May-24-2020, 02:17 AM Last Post: Larz60+
	SQLite Query in Python	rowyourboat	2	2,858	Apr-26-2019, 02:24 PM Last Post: Larz60+
	SQLite Query multiple column search	whacky7	6	8,550	Apr-01-2019, 09:29 PM Last Post: whacky7

Users browsing this thread: 1 Guest(s)