search « mysql « Java Database Q&A





1. How do i search for words in my text column? mysql?    stackoverflow.com

I have a column in my table which is of type text. The user may type any combination of words , it should appear in the result. Eg. Suppose string ...

2. Searching using MySQL: How to escape wildcards    stackoverflow.com

I am currently searching my database with a query (using JDBC) like this:

"... AND LCASE(Items.Name) LIKE '%" + searchString.toLowerCase() + "%';"
Now, this is obviously very bad, because it allows for SQL ...

3. text search in mysql jdbc    stackoverflow.com

I need to search throw a text field in mysql from my java application. Should I use a search engine like Lucene? Ideally it should support sql syntax. ...

4. How do i use a database and java to search for an object if given a description?    stackoverflow.com

i have a school project for biology where we need to make something to help us classify animals. We will be given a description with key traits that will define which ...

5. need MYSQL searching help    coderanch.com

I have a database build by MYSQL includes list of book names and price. when key in a book name, system will return it selling price. however, if user keyed in name wrongly, for exmaple. "risl management" instead of real name "risk management", my system won't know how to handle this type of problem. another problem is : if user doesn't ...

6. Searching for employee details in the MySQL database    coderanch.com

hi all, i am developing a program that needs to be used to search for employee details in our organisation. I would like either the firstname or the surname to be used as a search string. What i mean is if anyone wants to search for another person's details then they have to enter either the firstname or the surname to ...

7. Mysql keyword search    coderanch.com

Hi, Im looking at a form which searches for multiple keywords and brings back valid results like google but on a much smaller basis. The keywords would be in one field in one table in one database. I could do this easy with one word, how do i do this with multiple words? Thanks in advance Alan.

8. Java based search engine for MySQL database    coderanch.com

I don't know any way to do it IN the database, but you can do it outside the database with something like Lucene. You'd have an index step where you build a document for each entity in your database and index the document in Lucene. A search in Lucene will give you back the document name. Give the document a name ...

9. Need Help Searching MySQL Database    forums.oracle.com

Your problem is probably because you start a transaction via setAutoCommit(false) but never end the transaction via setAutoCommit(true). There is no need to have a transaction if your just reading data from a database. Therefore comment out setAutoCommit(). no data is read from the database until either you set autocommit(true) or do a conneciton.commit(). I suggest you get a connection, use ...