Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

MYSQL Command

02-11-2007 12:19PM

#1

randombar

Registered Users, Registered Users 2 Posts: 3,507 ✭✭✭

Join Date: March 2006

Posts: 3080

Looking for a command to find values in a column with more than 5 characters? or more than one word? Can mysql do this or is it a php thing?

0

Comments

#2 02-11-2007 12:21PM

nuada

Closed Accounts Posts: 68 ✭✭

Join Date: April 2007

Posts: 67

something like
select * from table where length(colunm) > 5;

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length

0
#3 02-11-2007 01:57PM

randombar

Registered Users, Registered Users 2 Posts: 3,507 ✭✭✭

Join Date: March 2006

Posts: 3080

Perfect NICE WAN!

0