sql - how to use concat columns of same table in Where condition -


user_id  | email_id  | type  --------------------------------------- 000121  | test1234   | ext 000125  | best_21    | lot 000128  | lite_21@   | ext 

i want use like

select * tablename concat (emailid,'',type) 'test1234 ext' 

but query not working

why not use

select * tablename emailid 'test1234' , type ' ext' 

Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -