Mysql Question - GoFuckYourself.com

Nails · 10-15-2007, 07:43 PM

Is there anyway using mysql only you can do a

select * from table where str_length('password') < 5

So way to get a return of all passwords with less then 5
characters in them?

Or do I need to use php?

BigBen · 10-15-2007, 08:14 PM

Code:

SELECT * FROM table WHERE CHAR_LENGTH(password) < 5;

Iron Fist · 10-15-2007, 08:16 PM

Last to the party

10-15-2007, 07:43 PM	#1
Nails Confirmed User Join Date: Jun 2007 Posts: 262	Mysql Question Is there anyway using mysql only you can do a select * from table where str_length('password') < 5 So way to get a return of all passwords with less then 5 characters in them? Or do I need to use php?

10-15-2007, 08:14 PM	#2
BigBen Confirmed User Join Date: Nov 2004 Location: scv Posts: 2,299	Code: SELECT * FROM table WHERE CHAR_LENGTH(password) < 5;

10-15-2007, 08:16 PM	#3
Iron Fist Too lazy to set a custom title Join Date: Dec 2006 Posts: 23,400	Last to the party __________________ i like waffles