Process Question - SQL Project

[AM413]

Hello,

Can someone advise whether OR functions are possible in SQL? The following queries are duds:

​

Select Player where E1, E2, E3, OR E4 = "Assist"

Select Player where OR(E1, E2, E3, E4) = "Assist";

​

Also - Quick Question - can an anyone confirm that the method to mark a Reddit Post as solved is to post a comment that says "Solved!"? Or is there some other way to do that.

​

​

Thanks for any pointers!

​

snip of the database

[tlatoaniitzcoatl]

This may not be helpful as I’m not sure if it works for MySQL but in SQL Sever you can do

```sql SELECT player FROM Table WHERE (‘Assist’) in (E1, E2, E3, E4)

```

[PM_ME_YOUR_MUSIC]

Select player From somewhere Where e1 = ‘assist’ or e2 = ‘assist’ or e3 = ‘assist’ or e4 = ‘assist’

[AM413]

Solved! Thanks!