is way can mysql to print out data name start from "A"?

chef · #1 22-Jan-2009, 21:51

is any way make mysql to print out data name only start from "A"?

admin · #2 23-Jan-2009, 05:29

If you want people here to help you out, you have to put some effort into your questions. Be very clear what you want because I don't want to assume all the time.

I am thinking that you want the SQL query to search for all names that start with "A"?

Code:

SELECT
	`name_first`,
	`name_last`
FROM
	`my_table`
WHERE
	`name_last` LIKE "A%"

Something like that should do the trick I think. I am not sure but I think MySQL searches TEXT & VARCHAR fields case-insensitively i.e. "A%" or "a%", it doesn't matter. Someone correct me if I am wrong.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find a mathematical formula for this recursion?	transgalactic	C Programming Language	8	12-Oct-2008 08:43
Memory leak when nothing is happening... How can I even debug this ?	Algar	MS Visual C++ / MFC Forum	10	19-Nov-2007 08:17
Asynchronous transfer question	crystalattice	Miscellaneous Programming Forum	2	24-Jan-2007 21:39
[Include] Doubly-linked List	dsmith	C Programming Language	6	14-Apr-2006 14:12
Guestbook error	BobbyDouglas	Web Design Forum	1	16-Oct-2003 23:17

is way can mysql to print out data name start from "A"?

Re: is way can mysql to print out data name start from "A"?