find elements of a varchar in another varchar

Posted by Luca Romagnoli on Stack Overflow See other posts from Stack Overflow or by Luca Romagnoli
Published on 2010-03-22T09:40:37Z Indexed on 2010/03/22 9:51 UTC
Read the original article Hit count: 434

Filed under:

varchar

|

where-clause

|

mysql

hi, i have a varchar field with the content like these:

a,b,c,d
e,d,a,c
b,q,d,e

i need to do a query that select only the rows with the field that has elements equals with an input string.

ex input: c,a

rows selected:

a,b,c,d
e,d,a,c

is possible without use the OR (field like '%a%' OR field like '%c%') ?

thanks

© Stack Overflow or respective owner

Related posts about varchar

varchar(255) to varchar(MAX)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to change a column type in a MS SQL 2008 database from varchar(255) to varchar(MAX) without having to drop the table and recreate? SQL Server Management Studio throws me an error every time I try to do it using that - but to save myself a headache would be nice to know if I can change… >>> More
find elements of a varchar in another varchar

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, i have a varchar field with the content like these: a,b,c,d e,d,a,c b,q,d,e i need to do a query that select only the rows with the field that has elements equals with an input string. ex input: c,a rows selected: a,b,c,d e,d,a,c is possible without use the OR (field like '%a%' OR field… >>> More
How to concat datatypes like integers(integer with integer) & varchar(varchar with varchar) in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we concat integers with integers varchar with varchar int with varchar in MySQL ? >>> More
what's wrong with mysql to create very long table fields?

as seen on Stack Overflow - Search for 'Stack Overflow'
mysql> create table balance_sheet( -> Cash_and_cash_equivalents VARCHAR(20), -> Trading_financial_assets VARCHAR(20), -> Note_receivable VARCHAR(20), -> Account_receivable VARCHAR(20), -> Advance_money VARCHAR(20), -> Interest_receivable VARCHAR(20)… >>> More
Android : SQL Lite insertion or create table issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Team, can anyone please help me to understand what could be the problem in the below snippet of code? It fails after insertion 2 and insertion 3 debug statements I have the contentValues in the Array list, I am iterating the arraylist and inserting the content values in to the database. Log.d("database"… >>> More

Related posts about where-clause

SQL join: where clause vs. on clause

as seen on Stack Overflow - Search for 'Stack Overflow'
After reading it, this is not a duplicate of Explicit vs Implicit SQL Joins. The answer may be related (or even the same) but the question is different. What is the difference and what should go in each? If I understand the theory correctly, the query optimizer should be able to use both interchangeably… >>> More
LINQ to XML : A query body must end with a select clause or a group clause

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone guide me on to repairing the error on this query : var objApps = from item in xDoc.Descendants("VHost") where(from x in item.Descendants("Application")) select new clsApplication { … >>> More
Difference b/w putting condition in JOIN clause versus WHERE clause

as seen on Stack Overflow - Search for 'Stack Overflow'
Suppose I have 3 tables. Sales Rep Rep Code First Name Last Name Phone Email Sales Team Orders Order Number Rep Code Customer Number Order Date Order Status Customer Customer Number Name Address Phone Number I want to get a detailed report of Sales for 2010. I would be doing a join. I… >>> More
Where clause in joins vs Where clause in Sub Query

as seen on Stack Overflow - Search for 'Stack Overflow'
DDL create table t ( id int Identity(1,1), nam varchar(100) ) create table t1 ( id int Identity(1,1), nam varchar(100) ) DML Insert into t( nam)values( 'a') Insert into t( nam)values( 'b') Insert into t( nam)values( 'c') Insert into t( nam)values( 'd') Insert into t( nam)values(… >>> More
SQL where clause to work with Group by clause after performing a count()

as seen on Stack Overflow - Search for 'Stack Overflow'
Tried my usual references at w3schools and google. No luck I'm trying to produce the following results. QTY is a derived column | Position | QTY -------------------- 1 Clerk 2 2 Mgr 2 Here's what I'm not having luck with: SELECT Position, Count(position) AS 'QTY' … >>> More