Hello. It is not clear for what does it mean without printing the result. Could you provide an example. If you don't want the variable to be in the column listing you can use such a technique: select * from ab where @variable:=1 and (other conditions).
Do not forget about SET syntax (it doesn't produce any result set at all). Jacek Becla wrote: > Hi, > > Can someone tell me how to assign result to a variable > inside SELECT without printing the result? > > Thanks, > Jacek -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]