Problems creating a search engine

[card51shor]

Hey so I'm trying to apply the code to my project and it's just not working. I just don't understand how to insert the SQL. why is it so complicated?

Where can I see where I can just learn how to type the SQL code? I don't get it. It shouldn't be this complicated. It's easier to write actual SQL code on its own. Why would Python make it more complicated? With all these placeholders and secret curly brackets and all this?

Your example is not taking user input so it doesn't really help me as far as syntax goes.

Thanks so much for taking the time, though.

Can someone please help me try to figure this out? I've been working on this project for 6 weeks and I just keep hitting a wall and I can't find solid documentation to back me up.

Please don't just send me the link to the documentation - it isn't specific and it's very confusing.

thank you!

Here is my code currently :

@app.route("/search", methods=["GET", "POST"])
def search():
    searchString = 'user'
    b = db.execute("SELECT * FROM books WHERE author LIKE :search", {'search': searchString}).fetchone()
    print(b)
    return render_template("search.html")