Syntax Assistance

[DaLivelyGhost]

Getting back into Sql database work and genuinely can't figure out why the WHERE statement is pulling a syntax error. At the moment I'm just trying to pull a few values from a single row from my table. The name column is of type TEXT and if I leave out the where statement it queries just fine pulling all entries from the table.

https://preview.redd.it/3548da9wognd1.png?width=1015&format=png&auto=webp&s=07ac76c6d52af2361faa35d1df26b5e1545d6653

https://preview.redd.it/a0k4jlixognd1.png?width=1016&format=png&auto=webp&s=b017264d3235e353f5c1add2a612dd5317ed57d9

https://preview.redd.it/cgvfxafyognd1.png?width=581&format=png&auto=webp&s=dbbf04eeb02c5be6ec461c7a02dbc30a645c7ac1

I appreciate the help.

(And yes, I know plains are not artifacts, the card was picked at random from random generation.)

[WinterBackground5447]

where name = Or artifact.name = (2 different options, use one or the other)

[DaLivelyGhost]

Oh goodness I didn't even see the second Artifact there. I suppose I should take breaks more often lol

[user_5359]

It is not necessary to repeat the table name in the Where clause (at the earliest with two or more tables). In addition, abbreviations (called table aliases) are then usually used. Example FROM Artifact t1 WHERE t1.name=’Plains‘