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?
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
[EMAIL PROTECTED] Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
