PostgreSQL SELECT WHERE IN - with value are special character

php postgresql

28 观看

1回复

3 作者的声誉

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

select * from t_user where mailAddress in ('mail1'@gmail.com, 'mail2&@gmail.com, &&&mail3''@gmail.com')

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


0

1 作者的声誉

Use http://php.net/manual/ru/pdo.prepared-statements.php + may be some query builder?

作者: sasha-ch 发布者: 2017 年 12 月 27 日
32x32