Python Forum

Guys, I am new to Python and would like to ask for assistance.
I am busy with a database using forms.
One of the things I have is a button on the form, basically giving me data in a table specified by a specific word.
The code for this is :

 cursor.execute("SELECT * FROM `stock` WHERE `stock_location` LIKE '%Not%'") 

Works fine, gives me the data I want, problem is I want another word inclujded in the data output.
I read online and tried all the examples, nothing works, either I get a blank sheet back or the same "single" specified word data as it normally will and or an error.
I tried the example code as I gave it here and added the AND and the OR many different ways but still no luck, please assist!!

(Sep-20-2018, 02:07 PM)compumarsh Wrote: [ -> ]Works fine, gives me the data I want, problem is I want another word inclujded in the data output

what does it mean another word included in the data? give an example. also post what have you tried

Hi, Thx for the reply. Basically I pull data from a table containing many phrases, for example....NOT in Stock.....In for Repairs....Handled.....Completed.
I basically only want the data containing the words......Not in Stock.....and then also.......Lost.
So I want the code to send me back the data in my form with only sentences which include the words...Lost and Not.
As per my code it works fine as I get the data from the one word specified in the code which is...not.
I n ow want to add another words so I get both back in one sheet.
I tried a few things already : This is the original Code that works for the one word : cursor.execute("SELECT * FROM stock WHERE stock_location LIKE '%Not%'")

I have tried SELECT * FROM stock WHERE stock_location LIKE '%Not%' AND '%Lost%'"
also : SELECT * FROM stock WHERE stock_location LIKE '%Not%' OR WHERE stock_location LIKE '%Lost%'"
and I tried : SELECT * FROM stock WHERE stock_location LIKE '%Not%', '%Lost%'

Fairly new to it all but here is also a complete section of what it looks like, as stated it works but only for the one word.

def Listmissing():
        Database()
        cursor.execute("SELECT * FROM `stock` WHERE `stock_location` LIKE '%Not%'")
        tree.delete(*tree.get_children())
        fetch = cursor.fetchall()
        for data in fetch:
            tree.insert('', 'end', values=(data))
        cursor.close()
        conn.close()

try

SELECT * FROM stock WHERE stock_location LIKE '%Not%' OR stock_location LIKE '%Lost%'

Works 100% Thank YOU!!!!!!!!!!!!!!!!!!