[mysql] I need help with querying just the first letters.

bliss · 12-17-2006, 11:27 PM

Anyone know how to do a query for a varchar field and only return query's that the first letter is up/lower case 'A' or up/lower case 'B' etc..

It is late and I have been coding all day long and my brain is fried. Please help or post examples I could look over. The % could be used, but I don't know how to use it.

Barrucadu · 12-18-2006, 12:10 AM

I think it would be:

Code:

SELECT * FROM `table` WHERE `field` REGEXP "^([a-zA-Z]+)([.*]+)"

bliss · 12-18-2006, 01:16 AM

I found it..

thanks, i think you misunderstand, but thank you for trying.

Code:

SELECT * FROM `table` WHERE `field` LIKE 'a%'

12-17-2006, 11:27 PM	THREAD STARTER #1 (permalink)
bliss NamePros Regular Join Date: Dec 2005 Posts: 950	[mysql] I need help with querying just the first letters. Anyone know how to do a query for a varchar field and only return query's that the first letter is up/lower case 'A' or up/lower case 'B' etc.. It is late and I have been coding all day long and my brain is fried. Please help or post examples I could look over. The % could be used, but I don't know how to use it.

12-18-2006, 12:10 AM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	I think it would be: Code: SELECT * FROM `table` WHERE `field` REGEXP "^([a-zA-Z]+)([.]+)" __________________ Website \| Blog* Arch Hurd developer; GNU Webmaster; FSF member #8385

12-18-2006, 01:16 AM	THREAD STARTER #3 (permalink)
bliss NamePros Regular Join Date: Dec 2005 Posts: 950	I found it.. thanks, i think you misunderstand, but thank you for trying. Code: SELECT * FROM `table` WHERE `field` LIKE 'a%'

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)