?
Solved

contains command

Posted on 2007-07-27
1
Medium Priority
?
227 Views
Last Modified: 2010-03-20
Hi ! i have a problem with contains command.

SELECT yazi_id from etiketler where contains(etiket,'basket')

i run this query. and in "etiket"field there is a word "basket" i know. but this query returns nothing. how to fix it?
0
Comment
Question by:btocakci
1 Comment
 
LVL 20

Accepted Solution

by:
dsacker earned 2000 total points
ID: 19583674
You could use the "like" statement, as well as compare lower case, just in case there are any mixed case characters.

select yazi_id
from etiketler
where lower(etiket) like '%basket%'
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question