how to compare strings in the table with other variable???

[rameshfaj]

Hi, I have a table which contains some variable characters.

I have some string variables generated from some program.What I want is that to get the entries from the table which has the variable characters(<,>,=) to that of the program generated variable.(i.e.like string comparision).Please send me the query model.

[fenway]

I don't understand your question.

[artacus]

So you have two variables right? One for the sign <,>,= and one string

 

So in PHP you would:

$query = "SELECT * FROM table WHERE field1 $sign '$str'";

So when php sends it to mysql it should look something like

 

SELECT * FROM table WHERE field1 > 'foo'