Where in('aa','na'dn') Problem

[wEb GuRu]

hi I am using a query like select * from cars where car_make in('BMW','Mercedes','Accura') But it gives an error if I use Single Qoute in any car_make for example... select * from cars where car_make in('BMW','Mercedes','Accura','infin'it') I am using MySQL with vb.net. THanks in advance Lets work it Out.........!

[benqazou]

If you were using SQL Server, you would have to write : select * from cars where car_make in('BMW','Mercedes','Accura','infin**''**it') For MySQL I am not sure, but try it this way.. I hope it'll work.

[J4amieC]

Use parameterised queries, or replace the quote with two quotes.

[benqazou]

In fact these are two single quotes (not a double quote).