On 10/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Gerard wrote: > > Currently I am running a concat statement to combine a field with a user > > name and domain to create and email address. In testing it looks like > > running the concat is a very slow command to run. The select statement > > currently looks like this. > > > > select concat(user,'@',domain),servername,port from database where > > concat(user,'@',domain)='[EMAIL PROTECTED]'; > > > > Why do CONCAT() twice? Couldn't you just do: > > WHERE user = 'username' AND domain = 'domain.com' > > Or am i missing something? > > brian > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
This is done because the application is not flexible. I can only put one condition in which goes for the where and select statement.