aspose file tools*
The moose likes JDBC and the fly likes select endswith Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "select endswith" Watch "select endswith" New topic
Author

select endswith

dibs dibley
Greenhorn

Joined: Aug 31, 2003
Posts: 13
Hi,
Is there anyway I can do something like an 'endsWith' in a Select statement to restrict the resultset that comes back from mysql?
I have a lookup on filenames, and would like to be able to restrict the select to .txt, .exe, .java, etc. etc. Is this possible, or do I have to get the whole resultset and then do an:
if (endsWith("txt")){
then
}
or something like that?

Thanks in advance,
Dibs
Gul Khan
Ranch Hand

Joined: Sep 03, 2003
Posts: 173
you can use the LIKE operator in your query string.
select * from <table> where <Column> LIKE '%txt'
This will give you the rows having column ending with txt.

Gul
Gary Joehlin
Greenhorn

Joined: Sep 18, 2003
Posts: 16
dibs dibley,
The answer given in the prior response is correct for most SQL syntax. Some implementations of the LIKE predicate (that's what the father of relational theory calls them. Just remember from high school English, when diagramming a sentence? The predicate is the 'action' taken upon the subject. And that's what most documentation calls that part of an SQL statement, the predicate) use a different 'wild-card' character.'
I've seen some use the asterisk '*', it's not an asterick, Rick wouldn't like that. Just remember from the famous speach, "I regret that i have one as-te-risk for my country". sorry for the digression, but that helps me to remember the correct pronunciation.
Some SQL implementations use one or the other, but rarely both.
If you find that the "%"- which means any character AND any number of characters in this position, returns no rows, then try the "*" in its exact place.
Keep in mind that this is not an "=" predicate, but a LIKE predicate, they are not interchangeable when looking for "patterns". The "=" predicate, of course, will check for an exact (not a pattern) match.
FYI, there are 7 predicate types in SQL, these are two of them
Best of luck and hope this expands your understanding of fundamentals of the power of SQL.
REgards,
Gary Joehlin
Colorado Springs, CO
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: select endswith
 
Similar Threads
Java Random
getting Date out with JSTL
How to specify multiple file suffices with regex
SELECT count(*) FROM ...
Accessing data in ResultSet object