Simple Select statement

[critical5]

Hi there,

I haven't used mysql for a while and I would like to know how to declare a variable for this: I want to be able to do the following but replace CP123 in the WHERE CLAUSE by whatever I specify. Possibly declare a variable??
Thanks

select DISTINCT *from memorandums
WHERE MEMO_REFERENCE = 'CP123'

 

[r937]

which application language are you using? they all have a different way of specifying variable valules

by the way, DISTINCT used with the dreaded, evil "select star" is redundant -- you should probably use neither

r937.com | rudy.ca

 

[johnwm]

You may also like to look at:

http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html

and possibly:

http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000297.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints