WHERE password = password('1234');
Curtis
On Thu, 4 Mar 2004, Victoria Reznichenko wrote:
> Scott Haneda <[EMAIL PROTECTED]> wrote:
> > Here is what I am doing now...
> >
> > SELECT id, first_name, last_name, password FROM account WHERE password =
> > ENCODE("1234", 'foobar') ORDER BY last_name LIMIT 0,10
> >
> > I need to do a where password LIKE '%1234%' instead, I can not seem to get
> > this to work, is there some trick?
>
> There is DECODE() function in MySQL. You can perform pattern-matching search for the
> decrypted password:
> SELECT .. FROM account WHERE DECODE(password, 'foobar') LIKE '%1234%' ORDER BY
> last_name LIMIT 0,10;
>
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
