Cyrus SASL SQL options

[Andreas Winkelmann]

Am Friday 30 June 2006 08:43 schrieb Berger, Stefan (IT - Management):

> TOP-Post?

http://en.wikipedia.org/wiki/Top-posting

> So, when there are so many possibilities, can someone post one or two of
> them?

> >> sasl_sql_select: SELECT password FROM mailusers WHERE account = '%u@%r'
> >>
> >> table mailusers containd all valid email accountss but now i have
> >> 2,3,4,5 tables with email accounts. so can i make 2,3,4,5 sas_sql_select
> >> entries?

sql_select:
(SELECT password FROM mailusers1 WHERE account = '%u@%r')
UNION
(SELECT password FROM mailusers2 WHERE account = '%u@%r')
UNION
(SELECT password FROM mailusers3 WHERE account = '%u@%r')

For example. One Line behind sql_select of course.

> > Look for union or views or maybe stored procedures.

Or Create a View and query the View.

CREATE VIEW allmailusers AS 
	(SELECT account, password FROM mailusers1)
	UNION
	(SELECT account, password FROM mailusers2)
	UNION
	(SELECT account, password FROM mailusers3);


sql_select: SELECT password FROM allmailusers WHERE account = '%u@%r'

Availability depends on your MySQL-Version and on your Tables of course.

-- 
	Andreas