error Unknown column in 'where clause' matlab using an array of strings

Question

I want to read a column from a table of data base and for every row that I have read, read some rows from another table. the elements that I read from both tables are Strings, my code is:

query1 = 'select col1 from MyDb.table1 order by col1'; 
[x1]= mysql(query1);
     for i=1:size(x1)
         my=char(x1(i,1));    
         query2=sprintf('%s%s%s%s',['select col1 from MyDb.table2 where col1=', my, ' or col2=', my]);
         [x2]=mysql(query2); 
     end

when I run the code I get this error:Unknown column 'khlkuu' in 'where clause', khlkuu is a row in first table. I know that this error is because of not surrounding khlkuu with quotation , but I do not know how to do so. any Ideas?

Related question: Why am I getting this error when creating an SQL query in MATLAB? — gnovice
– gnovice, Commented Oct 16, 2010 at 21:01

Jonas · Accepted Answer · 2010-10-16 14:24:40Z

4

To get quotes in a string, you need to use double-quotes. Also, the call to sprintf seems unnecessary.

my = 'something';
query2= ['select col1 from MyDb.table2 where col1=''', my, ''' or col2=''', my,'''']

query2 =
select col1 from MyDb.table2 where col1='something' or col2='something'

answered Oct 16, 2010 at 14:24

Jonas

75.1k10 gold badges139 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thn Over a year ago

thank you very much for your answer Jonas, you made it so easier :)

Collectives™ on Stack Overflow

error Unknown column in 'where clause' matlab using an array of strings

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related