MySQL equals this||that -

MySQL equals this||that -

before blasted note have google searched defining search term tricky solving problem.

i have select statement next clause:

where type = 1||3

does not work returns variations of type (1:6).

then tried:

where type = (1||3)

but returned type = 1 , excluded type equals 3.

how tell sql homecoming records type equals either 1 or 3 in way?

p.s. know can this: where type in (1,3)

but want know how using double bar operator?

you have rewrite whole type=? status this:

where type = 1 or type = 3 type = 1 || type = 3

if want where type 1 or 3, perfect utilize in (read out loud):

where type in (1, 3)

mysql