Query to find all entrys that start with $letter

Dev Shed Forums Sponsor:

SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!

June 23rd, 2000, 02:52 PM

kmilward

Junior Member

Join Date: Jun 2000

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Hi,

select * from tones_table where tone_name like '%A%';

I need a query that will find only records that start with a certain letter. Can anyone please help? The query above doesnt work.

Thanks...

June 23rd, 2000, 04:40 PM

rod k

Apprentice Deity

Join Date: Jul 1999

Location: Niagara Falls (On the wrong side of the gorge)

Posts: 3,237

Time spent in forums: 4 m 8 sec
Reputation Power: 13

select * from tones_table where tone_name like 'A%';

Viewing: Dev Shed Forums > Databases > MySQL Help > Query to find all entrys that start with $letter

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump