Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

CS-Cart · 10-13-2009, 07:09 AM

what you need is LIKE

select columnname from table where columnname LIKE 'A%';

you use like instead of = to use a match. The % can represent any number of characters. You can also use * which represents a single character.

10-13-2009, 07:09 AM	#2 (permalink)
CS-Cart Junior Member Join Date: Oct 2009 Posts: 2	Re: Displaying data from mysql what you need is LIKE select columnname from table where columnname LIKE 'A%'; you use like instead of = to use a match. The % can represent any number of characters. You can also use * which represents a single character.