PostgreSQL SELECT WHERE IN - with value are special character

php postgresql

28 观看


3 作者的声誉

I have a issue when using SELECT search query with condition such as below:

select * from t_user where mailAddress in ('mail1', 'mail2&, &&&mail3''')

Email in IN() is dynamic.

How I can use above query without change email address.

P/S : I use Postgresql

作者: user3363004 的来源 发布者: 2017 年 12 月 27 日

回应 (1)


1 作者的声誉

Use + may be some query builder?

作者: sasha-ch 发布者: 27.12.2017 06:32